Re: Oracle don't want to use indexes

From: Joseph <papers.box_at_gmail.com>
Date: Sun, 12 Aug 2007 12:22:28 -0700
Message-ID: <1186946548.716208.311910@d55g2000hsg.googlegroups.com>

On 12 Ago, 18:37, Jerome Vitalis <vitalismanN0S..._at_gmail.com.invalid> wrote:
> Joseph 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
>
> What about posting your queries, explain plans, and precise Oracle release?

Hi all!

thanks for your replies, i can aswer your questions only tomorrow morning. See you tomorrow..

Best Regards
Angelo Received on Sun Aug 12 2007 - 14:22:28 CDT