Sunday , June 16 2024

How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option

COLUMNSTORE_ARCHIVE option was introduced with SQL Server 2014. If we want to archive ColumnStore Tables or Indexes, we can compress our columnstore tables or indexes with this option.

For example, you partitioned a columnstore table by a date column. And you want to save space by compressing old partitions. In this case, you can compress old partitions with COLUMNSTORE_ARCHIVE option. So you can save up to 15 times.

Compress a ColumnStore Table

Decompress a ColumnStore Table

Compress a ColumnStore Index

Decompress a ColumnStore Index

Comress Only Some Partitions on a ColumnStore Table


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *