Ab Initio Interview Question:

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