You administer a SQL Server 2008 instance that contains a database named
AdventureWorks. You plan to use data compression to conserve disk space. You compress
a table named
VeryLarge that has a clustered index named Index1 and a non-clustered index named
Index2. Both indexes are partitioned. You execute the following Transact-SQL statement.
ALTER INDEX Index2 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
You need to ensure that all the indexes of the VeryLarge table are compressed by using
row-level compression. You need to accomplish this goal by using minimum resources.
Which Transact-SQL statement should you execute?
A.
ALTER INDEX ALL ON VeryLarge REBUILD PARTITION=ALL WITH
(DATA_COMPRESSION = ROW);
B.
ALTER INDEX ALL ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
C.
ALTER INDEX Index1 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
D.
ALTER INDEX Index1 ON VeryLarge REORGANIZE WITH (LOB_ COMPACTION = ON);