Post reply

Difference between Index and Table Compression?

  • April 11, 2013 at 10:36 am

    #273323

    If i have 1 Clustered ,4 Non-clustered indices and rebuild all these indices with Page compression enabled would that be equal to Table compression? If not whats the difference?

  • April 11, 2013 at 10:41 am

    #1605692

    Compressing the clustered index compresses the table as it is the table.

  • April 11, 2013 at 12:30 pm

    #1605730

    I think you mean row compession.. Page compression will also include row compression.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply