Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query not using indexes
"hastenthunder" <hastenthunder_at_hotmail.com> wrote in message news:<vL_Gc.576$Ny6.1485_at_mencken.net.nih.gov>...
> Hi,
>
> A query of mine in Oracle 9i R2 chooses to perform a full table scan of 1
> million row instead of using the index.
> I'm using CBO and just computed the statistics for the table.
>
> Can someone help?
>
> Thanks
I'd recommend that you check out Cary Millsap and Jeff Holt's paper on
event 10046 trace:
http://www.hotsos.com/dnloads/1/10046a/
(lots of other good papers at this site)
I'd recommend that you check out Wolfgang Brietling's paper on event
10053 trace.
http://www.centrexcc.com/
Papers - "A Look under the Hood of CBO: The 10053 Event"
Even if you don't read every detail provided in the resulting trace file, it will document all of the relevant optimizer settings for your instance and session (such as the db_file_multiblock_read_count - hint, hint).
have fun.
Pd Received on Fri Jul 09 2004 - 09:57:53 CDT