You have a database that uses stored procedures to perform INSERT, UPDATE, DELETE, and
SELECT statements. You are tasked with providing a recommendation of indexes to be created and
dropped from the database. You need to select the appropriate method to accomplish the task.
Which method should you use?
A.
Index Usage DMVs
B.
Missing Index DMVs
C.
SQL Server Profiler
D.
Database Engine Tuning Advisor