What should you do?

You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an application.

You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.

What should you do?
A . Query the sys.dm_db_index_usage_stats DM
C . Query the sys.dm_db_missing_index_details DM
E . Use the Database Engine Tuning Advisor.
F . Query the sys.dm_db_missing_index_columns DM

View Answer

Answer: C

Explanation:

Reference: http://msdn.microsoft.com/en-us/library/ms174202.aspx