Re: Wrong Results - Bad Execution Plan
- From: "Henry Poras" <henry@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 19 Nov 2007 14:32:02 -0500
Matt,
Could be, but I don't think so. As far as I can see, the issue is that the
optimizer applies two operations in the wrong order. It does VIEW then
FILTER but it should do FILTER then VIEW. Can prefetch change the optimizer
execution order to do something logically incorrect?
Henry
> -----Original Message-----
> From: Adams, Matthew (GE Indust, ConsInd) [mailto:MATT.ADAMS@xxxxxx]
> Sent: Monday, November 19, 2007 1:21 PM
> To: henry@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Subject: RE: Wrong Results - Bad Execution Plan
>
>
> Are you referring to the bug discussed in note 406966.1?
>
> ----
> Matt Adams - GE Consumer and Industrial
> Database Administration
> It will make sense as soon as you stop thinking logically
> and start thinking oracle-ly. - Jim Droppa
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Henry Poras
> Sent: Monday, November 19, 2007 11:25 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Wrong Results - Bad Execution Plan
>
>
> I'll post it if and when I get it. If this is an existing bug
> I haven't
> tracked it down yet. If it is new, Oracle hasn't assigned a
> bug# to it (they
> are still playing the 'send me your poor, your tired database
> and I'll see
> what I can do' game.).
>
> Henry
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
