You are a database administrator for AIOTestKing.com. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use?

A.
DBCC INDEXDEFRAG

B.
SELECT * FROM sys.dm_db_index_physical_stats

C.
SELECT * FROM sys.indexes

D.
DBCC DBREINDEX

Explanation:
The index_physical_stats function takes five parameters: database_id, object_id, index_id, partition_id, and mode. This function returns row size and fragmentation information.