Ab Initio Data Warehousing Question:

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

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

Previous Question	Next Question
Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e.: a test and production copy of a database)?	How to create repository in abinitio for stand alone system(LOCAL NT)?