Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!hammer.uoregon.edu!canoe.uoregon.edu!mencken.net.nih.gov!not-for-mail
From: "hastenthunder" <hastenthunder@hotmail.com>
Newsgroups: comp.databases.oracle.server
References: <vL_Gc.576$Ny6.1485@mencken.net.nih.gov> <C20Hc.476$em4.117@newsfe3-gui.ntli.net>
Subject: Re: Query not using indexes
Lines: 31
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: <kj%Gc.577$Ny6.1552@mencken.net.nih.gov>
Date: Wed, 7 Jul 2004 19:04:56 -0400
NNTP-Posting-Host: 199.249.158.90
X-Trace: mencken.net.nih.gov 1089241424 199.249.158.90 (Wed, 07 Jul 2004 19:03:44 EDT)
NNTP-Posting-Date: Wed, 07 Jul 2004 19:03:44 EDT
Xref: core-easynews comp.databases.oracle.server:225176
X-Received-Date: Wed, 07 Jul 2004 16:02:53 MST (news.easynews.com)


"Dave" <david.sharples3@ntlXworld.com> wrote in message
news:C20Hc.476$em4.117@newsfe3-gui.ntli.net...
>
> "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 -
>
>

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