Home » SQL & PL/SQL » SQL & PL/SQL » Query Slow (Oracle 10g)
Query Slow [message #330799] Tue, 01 July 2008 05:50 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,
I have gathered statistics and am having b tree index on the column , but still query is not using that index.What needs to be done.

Re: Query Slow [message #330801 is a reply to message #330799] Tue, 01 July 2008 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing, if your statistics are up to date and Oracle chooses to not use the index, then it is better to not use the index.

Regards
Michel
Re: Query Slow [message #330802 is a reply to message #330801] Tue, 01 July 2008 06:03 Go to previous messageGo to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Ok.But on what basis oracle will choose whether to use index (eventhough we have) or not .
Re: Query Slow [message #330805 is a reply to message #330802] Tue, 01 July 2008 06:05 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Statistics.

Regards
Michel
Previous Topic: how to Find hardisk ID
Next Topic: Statistics locked
Goto Forum:
  


Current Time: Wed Dec 07 14:59:53 CST 2016

Total time taken to generate the page: 0.14218 seconds