Home » SQL & PL/SQL » SQL & PL/SQL » index help (oracle 9i,windows xp)
index help [message #353047] Fri, 10 October 2008 14:11 Go to next message
imraan
Messages: 21
Registered: June 2008
Location: ayangudi
Junior Member
hi;


what will happen internally when we rebuild the index;


why sometimes index is not used after creating or rebuild the index;

pls explain me
Re: index help [message #353048 is a reply to message #353047] Fri, 10 October 2008 14:16 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>why sometimes index is not used after creating or rebuild the index;
* bad sql
* based on available stats, CBO might have decided not to use an index
* outdated statistics.
Previous Topic: Error Creating a Database trigger
Next Topic: QUERRY Help
Goto Forum:
  


Current Time: Sat Dec 10 04:52:37 CST 2016

Total time taken to generate the page: 0.10904 seconds