Re: Oracle don't want to use indexes

From: Jerome Vitalis <vitalismanN0SP4M_at_gmail.com.invalid>
Date: Sun, 12 Aug 2007 18:37:48 +0200
Message-ID: <46bf3759$0$5451$79c14f64@nan-newsreader-05.noos.net>

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? Received on Sun Aug 12 2007 - 11:37:48 CDT

This message: [ Message body ]
Next message: DA Morgan: "Re: Transitioning to Oracle: How can you list out the names of all tables and fields?"
Previous message: DA Morgan: "Re: reorg of Oracle10g tablespace in offline mode"
In reply to: Joseph: "Oracle don't want to use indexes"
Next in thread: Joseph: "Re: Oracle don't want to use indexes"
Reply: Joseph: "Re: Oracle don't want to use indexes"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US