Which of these commands would defragment the clustered as well as the secondary indexes of any given specified table?
A. DBCC CHECKDB
B. DBCC SHOWCONTIG
C. DBCC INDEXDEFRAG
D. DBCC CATALOG
Answer:C
Which of these commands would defragment the clustered as well as the secondary indexes of any given specified table?
A. DBCC CHECKDB B. DBCC SHOWCONTIG C. DBCC INDEXDEFRAG D. DBCC CATALOG