Re: Query not using indexes

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Wed, 07 Jul 2004 23:54:10 GMT
Message-ID: <C20Hc.476$em4.117@newsfe3-gui.ntli.net>

"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
>
>

exec dbms_stats.gather_table_stats('SCHEMA_NAME','TABLE_NAME,casacde=true)

are you sure a fts is a bad thing - Received on Wed Jul 07 2004 - 18:54:10 CDT