You discover that all indexes of the Sales table on your SQL Server 2005 database server are heavily
fragmented.
You need to decrease the fragmentation of all indexes of the Sales table to a minimum, while keeping the Sales
table available to all users.
What should you do?
A.
Defragment the disk that contains the Sales table.
B.
Execute the following statement.
USE master;
GO
DBCC CLEANTABLE (‘DB1′,’sales’);
GO
C.
Execute the following statement.
USE DB1;
GO
ALTER INDEX ALL ON sales
REORGANIZE WITH (LOB_COMPACTION = ON);
GO
D.
Execute the following statement.
USE DB1;
GO
ALTER INDEX ALL ON sales
REBUILD;
GO