SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Data Compression: Table vs Clustered Index
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1754 Posts

Posted - 05/01/2013 :  13:13:53  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3706 Posts

Posted - 05/01/2013 :  13:53:20  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
1754 Posts

Posted - 05/01/2013 :  15:37:37  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000