CODEWITHSUNDEEP
sql-serverindexingcompression
Diego
Diego

Reputation: 36176

Table Compression and clusterd index compresison

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

Answers (1)

gbn
gbn

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

Related Questions