How would you find out whether a SQL query is using the indices you expect?

  • Interview Candidate
  • 1
  • 3289

Showing Answers 1 - 1 of 1 Answers

siddharth ranga

  • Sep 29th, 2005
 

explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions