Re: Wrong Results - Bad Execution Plan

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_at_ge.com]
> Sent: Monday, November 19, 2007 1:21 PM
> To: henry_at_itasoftware.com; oracle-l_at_freelists.org
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Henry Poras
> Sent: Monday, November 19, 2007 11:25 AM
> To: oracle-l_at_freelists.org
> 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
>

--
http://www.freelists.org/webpage/oracle-l