Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!proxad.net!newsfeed.stueberl.de!ecngs!feeder.ecngs.de!62.253.162.219.MISMATCH!news-out.ntli.net!newsrout1.ntli.net!news-in.ntli.net!ntli.net!newspeer1-win.ntli.net!newsfe3-gui.ntli.net.POSTED!53ab2750!not-for-mail
From: "Dave" <david.sharples3@ntlXworld.com>
Newsgroups: comp.databases.oracle.server
References: <vL_Gc.576$Ny6.1485@mencken.net.nih.gov>
Subject: Re: Query not using indexes
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Message-ID: <C20Hc.476$em4.117@newsfe3-gui.ntli.net>
Date: Wed, 07 Jul 2004 23:54:10 GMT
NNTP-Posting-Host: 213.107.232.113
X-Complaints-To: http://www.ntlworld.com/netreport
X-Trace: newsfe3-gui.ntli.net 1089244450 213.107.232.113 (Wed, 07 Jul 2004 23:54:10 GMT)
NNTP-Posting-Date: Wed, 07 Jul 2004 23:54:10 GMT
Organization: ntlworld News Service
Xref: core-easynews comp.databases.oracle.server:225175
X-Received-Date: Wed, 07 Jul 2004 15:53:05 MST (news.easynews.com)


"hastenthunder" <hastenthunder@hotmail.com> wrote in message
news:vL_Gc.576$Ny6.1485@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 -