SQL 2016 Tables & Indexes compression

Question

Hello, SQL 2016 to save space we are aiming to do compression on Tables & their Indexes.

Is there any specific order which to run compression first Table first then Indexes or Indexes first and then Tables?

Anything else to be aware or make note of?

Thanks in advance.

Answer 1

Hi,

>Is there any specific order which to run compression first Table first then Indexes or Indexes first and then Tables?

There does not seem to be any specified order. It depends on the objects you want to compress. Data compression
I will consider the table first, and then the non-clustered index.

>Anything else to be aware or make note of?

Please refer to the Limitations and Restrictions section in this document.
https://learn.microsoft.com/en-us/sql/relational-databases/data-compression/enable-compression-on-a-table-or-index?view=sql-server-ver15

Answer 2

Thanks for the reply Criszhan-msft