Q. 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
💬 Discuss
✅ Correct Answer: (C) DBCC INDEXDEFRAG

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:10 am in SQL Server

You must be Logged in to update hint/solution

💬 Discussion

📊 Question Analytics

👁️
562
Total Visits
📽️
4 y ago
Published
🎖️
Vinay Kumar
Publisher
📈
80%
Success Rate