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?()
- A、DBCC DBREINDEX
- B、SELECT * FROM sys.dm_db_index_physical_stats
- C、DBCC INDEXDEFRAG
- D、SELECT * FROM sys.indexes
正确答案:B
答案解析:有
微信扫一扫手机做题