Re: Query not using indexes

From: hastenthunder <hastenthunder_at_hotmail.com>
Date: Wed, 7 Jul 2004 19:04:56 -0400
Message-ID: <kj%Gc.577$Ny6.1552@mencken.net.nih.gov>

"Dave" <david.sharples3_at_ntlXworld.com> wrote in message news:C20Hc.476$em4.117_at_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 -
>
>

Done that. Computed fresh statistics before sending the issue out via analyze table command (its old, I know). Just did it again using dbms_stats, still does not work... Strange.., the query certainly access a substantial number of rows.... Received on Wed Jul 07 2004 - 18:04:56 CDT