QUESTION 11
You administer a SQL Server 2008 infrastructure. You plan to design a maintenance strategy for a mission-critical database that includes a large table named Orders. The design plan includes index maintenance operations. You must design the strategy after considering the following facts:
* The Orders table in the database is constantly accessed.
* New rows are frequently added to the Orders table.
* The average fragmentation for the clustered index of the Orders table is less than 2 percent.
* The Orders table includes a column of the xml data type.
You need to implement the strategy so that the performance of the queries on the table is optimized. What should you do?
A. Drop the clustered index of the Orders table.
B. Rebuild the clustered index of the Orders table offline once a month.
C. Reorganize the clustered index of the Orders table by decreasing the fill factor.
D. Exclude the clustered index of the Orders table from scheduled reorganizing or rebuilding operations.
Read More