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