Valid 70-764 Dumps shared by PrepAwayExam.com for Helping Passing 70-764 Exam! PrepAwayExam.com now offer the newest 70-764 exam dumps, the PrepAwayExam.com 70-764 exam questions have been updated and answers have been corrected get the newest PrepAwayExam.com 70-764 dumps with Test Engine here:
You have a database named Saleshistory that records sales transactions for your organization. You create indexes in the database. The database has grown over time and now contains hundreds of indexes. You need to identify the indexes that are not being used. Which dynamic management object should you use?
Correct Answer: B
Explanation/Reference: Explanation: The sys.dm_db_index_usage_stats returns counts of different types of index operations and the time each type of operation was last performed. The user_updates counter indicates the level of maintenance on the index caused by insert, update, or delete operations on the underlying table or view. You can use this view to determine which indexes are used only lightly by your applications. You can also use the view to determine which indexes are incurring maintenance overhead. You may want to consider dropping indexes that incur maintenance overhead, but are not used for queries, or are only infrequently used for queries. Reference: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/ sys-dm-db-index-usage-stats-transact-sql