You have an Azure SQL database named DB1 that contains a nonclustered index named index1. End users report slow queries when they use index1. You need to identify the operations that are being…

The correct answer is D. Sys.dm_db_index_useage_stats. Every individual seek, scan, lookup, or update on the specified index by one query execution is counted as a use of that index and increments the corresponding counter in this view. Information is reported both for operations caused by user-submitted queries, and for operations…

Submitted by jordan8· Mar 6, 2026Optimize query performance

Question

You have an Azure SQL database named DB1 that contains a nonclustered index named index1. End users report slow queries when they use index1. You need to identify the operations that are being performed on the index. Which dynamic management view should you use?

Options

ASys.dm_exec_query_plan_stats
BSys.dm_db_index_physical_stats
CSys.dm_db_index_operational_stats
DSys.dm_db_index_useage_stats

How the community answered

(45 responses)

A
7% (3)
B
2% (1)
C
2% (1)
D
89% (40)

Explanation

Every individual seek, scan, lookup, or update on the specified index by one query execution is counted as a use of that index and increments the corresponding counter in this view. Information is reported both for operations caused by user-submitted queries, and for operations caused by internally generated queries, such as scans for gathering statistics. https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management- views/sys-dm-db-index-usage-stats-transact-sql?view=sql-server-ver16#remarks

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice