Home » SQL & PL/SQL » SQL & PL/SQL » Question on indexes
Question on indexes [message #237340] Mon, 14 May 2007 03:40 Go to next message
caliguardo
Messages: 107
Registered: February 2007
Location: Chennai
Senior Member

If there are two indices are created for a particular column, while executing a query ,how to identify which index is firing?
Re: Question on indexes [message #237349 is a reply to message #237340] Mon, 14 May 2007 03:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Use Explain plan to find which index was used.
Use trace even 10053 to find why that particular index was chosen.
Re: Question on indexes [message #237358 is a reply to message #237349] Mon, 14 May 2007 04:27 Go to previous messageGo to next message
caliguardo
Messages: 107
Registered: February 2007
Location: Chennai
Senior Member

when i type select * from explain_plan it says table or view does not exist....is explain_plan is not a in built table?
Re: Question on indexes [message #237361 is a reply to message #237358] Mon, 14 May 2007 04:32 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/ex_plan.htm#PFGRF009
Previous Topic: More reading
Next Topic: Anonymous blocks.
Goto Forum:
  


Current Time: Wed Dec 07 22:08:38 CST 2016

Total time taken to generate the page: 0.21113 seconds