Which command takes corrective action on a fragmented index?
A)ALTER INDEX REORGANIZE
B)UPDATE INDEX REBUILD
C)REINDEX DATABASE
D)UPDATE STATISTICS

Question

Quizplus · Accepted Answer

The ALTER INDEX REORGANIZE command is used specifically to defragment an index, by compacting its pages and reordering its leaf nodes. This helps to reduce fragmentation and storage space, as well as improve overall performance. UPDATE INDEX REBUILD and REINDEX DATABASE are also used to rebuild indexes, but are more intrusive and time-consuming processes, while UPDATE STATISTICS updates the distribution of values in column statistics and does not address index fragmentation directly.

Which Command Takes Corrective Action on a Fragmented Index