Which command should you use only during the monthly maintenance window?

You are designing your maintenance plan.

Which command should you use only during the monthly maintenance window?
A . DBCC INDEXDEFRAG (ProdDB, SalesOrderDetail, SODIndex)
B . ALTER INDEX SODIndex ON SalesOrderDetail REORGANIZE
C . ALTER INDEX SODIndex ON SalesOrderDetail REBUILD
D . ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON)

View Answer

Answer: D

Explanation:

* Scenario: Database Issues

The current database does not perform well. Additionally, a recent disk problem caused the system to go down, resulting in lost sales revenue. In reviewing the current system, you found that there are no automated maintenance procedures. The database is severely fragmented, and everyone has read and write access.

* After the degree of fragmentation is known, use the following table to determine the best method to correct the fragmentation.

avg_fragmentation_in_percent value

/ > 5% and < = 30%

then use

ALTER INDEX REORGANIZE

/ > 30%

then use

ALTER INDEX REBUILD WITH (ONLINE = ON)