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

Submitted by: Administrator
Explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not.
Submitted by: Administrator

Read Online Ab Initio Job Interview Questions And Answers