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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1834 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

3873 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
1834 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  
 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.16 seconds. Powered By: Snitz Forums 2000