Re: Query not using indexes

Hi,

i have very often this cases:

i do an:

alter session set optimizer_goal = rule (obsolete in Oracle 10g)

select /*+ rule */ from ...

also try /*+ first_rows */ or /*+ index(<table_name> <index-name>) */

instead of rule,

regards,

Toni

In article <vL_Gc.576$Ny6.1485_at_mencken.net.nih.gov>, hastenthunder <hastenthunder_at_hotmail.com> wrote:

> 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
>
>
Received on Thu Jul 08 2004 - 10:21:18 CDT