Bradley B (11/10/2010)
Example:Table Customer, with Clustered Index Customer_Clustered
you can page compress Customer, and row compress Customer_Clustered.
If the table has a clustered index the table and clustered index are essentially the same thing. So if you page compress the table and then row compress the clustered index, the table/clustered index will be row compressed and duplicate work is done.
The following statements net the same result.
ALTER TABLE Customer REBUILD WITH (DATA_COMPRESSION = PAGE);
ALTER INDEX Customer_Clustered ON Customer REBUILD WITH (DATA_COMPRESSION = PAGE);
Non-clustered indexes however can have different compression than the clustered index/table.