Re: Is this an bug in Oracle's SQL compiler

Mike Burden wrote:

> 1) I've fully qualified all the columns and it made no difference.
> 2) Do you mean my plan table is out of date or that you need more
> information from the plan table? The alias name would be useful but I can't
> see a reference to this.
>

Hi

It is a bug in 8.1.6

8.1.7 should be OK

Workaround for 8.1.6 is event 10167:
alter session set events '10167 trace name context forever,level 1'; (disable index min/max scan ).

--
Kari

(Mr.) Kari Pannila
      Oracle DBA (OCP)
--

PS. Delete X from my mail address , it (X) is only for SPAMMERS.
    Poista X mail-osoitteen edestä, se on SPAMmereita varten.