You are the administrator of your company network. And you’re in charge of a SQL Server 2008 infrastructure. Now you intend to design a maintenance strategy for a mission-critical database.
And the database has a large table named DPT. Index maintenance operations are also included in the design plan. When designing the strategy, you must consider the following matters:The DPT table contains a column of the xml data type and is constantly accessed. New rows are frequently added to the DPT table. The average fragmentation for the clustered index of the Orders table is less than 2 percent. In order to optimize the performance of the queries on the table, you have to run the strategy. So what should you do?
A.
You should drop the clustered index of the DPT table.
B.
You should rebuild the clustered index of the DPT table offline once a month.
C.
You should reorganize the clustered index of the DPT table by decreasing the fill factor.
D.
You should exclude the clustered index of the Orders table from scheduled reorganizing or rebuilding operations.