Reputation: 36176
I'm almost 100% sure there isn't any, but just to confirm.
Is there any difference between applying compression to a table and applying compression to the table's clustered index?
Upvotes: 0
Views: 73
Reputation: 432742
No effective difference. The data is the index at the lowest level of the B-Tree index structure.
The tree of the index is typically tiny compared to the data: I don't know if this compresses
Upvotes: 2