question

techresearch7777777-7743 avatar image
0 Votes"
techresearch7777777-7743 asked techresearch7777777-7743 answered

SQL 2016 Tables & Indexes compression

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.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft edited

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://docs.microsoft.com/en-us/sql/relational-databases/data-compression/enable-compression-on-a-table-or-index?view=sql-server-ver15

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

techresearch7777777-7743 avatar image
0 Votes"
techresearch7777777-7743 answered

Thanks for the reply Criszhan-msft

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.