You need to perform the following maintenance tasks: Identify unused indexes

DRAG DROP
You have a database named database1. Each table in database1 has one index per column.
Users often report that creating items takes a long time.
You need to perform the following maintenance tasks:
Identify unused indexes.
Identify indexes that need to be defragmented.
What should you use?
To answer, drag the appropriate function to the correct management task in the answer
area. (Answer choices may be used once, more than once, or not at all.)

DRAG DROP
You have a database named database1. Each table in database1 has one index per column.
Users often report that creating items takes a long time.
You need to perform the following maintenance tasks:
Identify unused indexes.
Identify indexes that need to be defragmented.
What should you use?
To answer, drag the appropriate function to the correct management task in the answer
area. (Answer choices may be used once, more than once, or not at all.)

Answer:

Explanation:

Note:
* sys.dm_db_index_usage_stats
Returns counts of different types of index operations and the time each type of operation
was last performed.
* sys.dm_db_index_physical_stats
Returns size and fragmentation information for the data and indexes of the specified table or
view.



Leave a Reply 0

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