Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Data Compression: Table vs Clustered Index

Author  Topic 

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2013-05-01 : 13:13:53
Quick Question: Is there any difference between applying data compression to the table versus applying it to the clustered index (assuming there is a clustered index)?

=================================================
There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-05-01 : 13:53:20
To my simple-minded way of thinking, a clustered index IS the table from a storage perspective. So I would think that compression on one is the same as compression the other. Reading between the lines on this MSDN page, they seem to suggest the same as well: http://msdn.microsoft.com/en-us/library/cc280449.aspx i.e., a clustered index is not even listed as an object on which you can apply compression.

Data compression can be configured for the following database objects:
•A whole table that is stored as a heap.
•A whole table that is stored as a clustered index.
•A whole nonclustered index.
•A whole indexed view.


Go to Top of Page

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2013-05-01 : 15:37:37
Thanks for the feedback. I suspect that there is no difference but thought someone might have a definitive answer. The syntax is allowed and supported for clustered indexes.

=================================================
There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber
Go to Top of Page
   

- Advertisement -