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.
| 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. |
 |
|
|
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 |
|
|
|
|
|
|
Data Compression: Table vs Clustered Index