You are a database&#

You are a database administrator for your company. 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？（）

• ADBCC DBREINDEX
• BSELECT * FROM sys.dm_db_index_physical_stats
• CDBCC INDEXDEFRAG
• DSELECT * FROM sys.indexe