OraFAQ Forum: SQL & PL/SQL » Question on indexes

Home » SQL & PL/SQL » SQL & PL/SQL » Question on indexes

Mon, 14 May 2007 03:40

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?

Mon, 14 May 2007 03:57

Mahesh Rajendran
Messages: 10708
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.

Mon, 14 May 2007 04:27

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?

Mon, 14 May 2007 04:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Previous Topic:	More reading
Next Topic:	Anonymous blocks.

Goto Forum:

]

Current Time: Thu Dec 05 14:14:29 CST 2024