Re: Oracle don't want to use indexes

From: R.Wang <wangr_at_douglas.bc.ca>
Date: Fri, 17 Aug 2007 04:58:52 -0000
Message-ID: <1187326732.411373.40900@j4g2000prf.googlegroups.com>

On Aug 12, 8:28 am, Joseph <papers...._at_gmail.com> wrote:
> Hi Folks!
>
> We have an oralce 9i that from 2 weeks seems to have troubles in
> performace. Seems that oracle don't want use indexes for 2 of our
> largest tables and many sql queries access in full table scan. what's
> happening?
>
> MAny Thanks
> BR

Hi BR,

Please see my posting at
http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/06b37d0a44f187f8/dcf60ce91728d296#dcf60ce91728d296

Here, what I'd like to say is that CBO is not perfect and sometime it make wrong decision. I mean what time and how to do object analyzing is very important.

Good luck.

R.Wang
http://www.oraclepoint.com Received on Thu Aug 16 2007 - 23:58:52 CDT