Which of the following command defragments clustered and secondary indexes of the specified table ?
A. DBCC SHOWCONTIG
B. DBCC CHECKDB
C. DBCC CATALOG
D. DBCC INDEXDEFRAG
Answer:A
Which of the following command defragments clustered and secondary indexes of the specified table ?
A. DBCC SHOWCONTIG B. DBCC CHECKDB C. DBCC CATALOG D. DBCC INDEXDEFRAG
Explanation:DBCC INDEXDEFRAG is an online operation, so it does not hold long-term locks that can block running queries or updates.