Which of the following is the correct Transact-SQL statement for achieving your goal?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has an existing SQL Server 2012 database that has multiple tables. These tables are
configured to contain a single index for every column.
When you are informed that item creation is slow, you decide to find indexes that require
defragmentation.
Which of the following is the correct Transact-SQL statement for achieving your goal?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has an existing SQL Server 2012 database that has multiple tables. These tables are
configured to contain a single index for every column.
When you are informed that item creation is slow, you decide to find indexes that require
defragmentation.
Which of the following is the correct Transact-SQL statement for achieving your goal?

A.
The sys.dm_db_missing_index_group_stats Transact-SQL statement.

B.
The sys.dm_db_index_physical_stats Transact-SQL statement.

C.
The sys.dm_db_index_usage_stats Transact-SQL statement.

D.
The sys.dm_db_index_operational_stats Transact-SQL statement.

Explanation:



Leave a Reply 1

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