You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer. The performance of the server has degraded to a great extent over time. You are troubleshooting the indexing environment. You rebuild the clustered indexes that are used the most frequently. You want to optimize the most frequently accessed nonclustered index. You access the sys.dm_db_index_usage_stats dynamic management view (DMV). The results are shown in the following table.
You need to identify which nonclustered index is being used the most frequently when the entire index is not read. Which object_id and index_id combination should you use?
A.
Use the object_id 309576141 and the index_id 1.
B.
Use the object_id 2066106401 and the index_id 2.
C.
Use the object_id 869578136 and the index_id 1.
D.
Use the object_id 2066106401 and the index_id 1.
E.
Use the object_id 869578136 and the index_id 5.