SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how can i know which index will be used when executing the query ?

user10685034Feb 4 2011 — edited Feb 5 2011

1 ) I have query in which i have 3-4 tables but there multiple index on one column .
so how can i know which index will be used when executing the query ?

2) I have a query which ia taking too much time . how can i know which table is taking too much time ?

3) Please Provide me some document of EXplain plan ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2011

Added on Feb 4 2011

7 comments

512 views