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:
http://technet.microsoft.com/en-us/library/ms188917.aspx