![]() ![]() For more information, see COMPRESS (Transact-SQL). Data compressed using the COMPRESS function cannot be indexed. This is an additional step and is most suitable for compressing portions of the data when archiving old data for long-term storage. For partitioned columnstore tables and columnstore indexes, you can configure the archival compression option for each partition, and the various partitions do not have to have the same archival compression setting.ĭata can also be compressed using the GZIP algorithm format.A whole nonclustered columnstore index.Since a columnstore table is stored as a clustered columnstore index, both approaches have the same results. A whole columnstore table or a whole clustered columnstore index.You can configure columnstore archival compression on the following database objects: Use columnstore archival compression to further reduce the data size for situations when you can afford extra time and CPU resources to store and retrieve the data. For partitioned tables and indexes, you can configure the compression option for each partition, and the various partitions of an object do not have to have the same compression setting.įor columnstore tables and indexes, all columnstore tables and indexes always use columnstore compression and this is not user configurable.A whole table that is stored as a clustered index.A whole table that is stored as a heap.You can configure row and page compression on the following database objects: However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. In addition to saving space, data compression can help improve performance of I/O intensive workloads because the data is stored in fewer pages and queries need to read fewer pages from disk. SQL Server, Azure SQL Database, and Azure SQL Managed Instance support row and page compression for rowstore tables and indexes, and support columnstore and columnstore archival compression for columnstore tables and indexes.įor rowstore tables and indexes, use the data compression feature to help reduce the size of the database. Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |