You need to identify which nonclustered indexes are unu…

DRAG DROP
You need to identify which nonclustered indexes are unused by queries.How should you complete the statement? To answer, drag the appropriate values to the correct locations. Each
value may be used once, more than once, or not at all. You may need to drag the split bar between panes or
scroll to view content.
Select and Place:

DRAG DROP
You need to identify which nonclustered indexes are unused by queries.How should you complete the statement? To answer, drag the appropriate values to the correct locations. Each
value may be used once, more than once, or not at all. You may need to drag the split bar between panes or
scroll to view content.
Select and Place:

Answer:

Explanation:
Box 1: sys.dm_db_index_usage_stats
sys.dm_db_index_usage_stats shows you how many times the index was used for user queries. It returns
counts of different types of index operations and the time each type of operation was last performed in SQL
Server.
Box 2: sys.indexes
sys.indexes contains a row per index or heap of a tabular object, such as a table, view, or table-valued function.
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/
sys-dm-db-index-usage-stats-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-indexes-transact-sql



Leave a Reply 0

Your email address will not be published. Required fields are marked *