Features

Online nonclustered columnstore index rebuild in SQL Server

When rebuilding a columnstore index, the Database Engine reads all data from the original columnstore index, including the delta store. It combines data into new row groups, and compresses all row groups into columnstore. The Database Engine defragments the columnstore by physically deleting rows that have been marked as deleted. When rebuilding an index and the ONLINE option is set to ON, the underlying objects, the tables and associated indexes, are available for queries and data modification. You can also rebuild online a portion of an index residing on a single partition. Exclusive table locks are held only for a very short amount of time during the alteration process.. GeoPITS brings you the comprehensive details of Online nonclustered columnstore index rebuild's support in different versions & editions of SQL Server.

Explore Online nonclustered columnstore index rebuild In Different SQL server Versions & Editions

VersionEnterpriseStandardWebExpress (Adv.)Express
Version v2019 Yes
Version v2017 Yes
Version v2016
Version v2014
Version v2012

Frequently Asked Questions

When rebuilding a columnstore index, the Database Engine reads all data from the original columnstore index, including the delta store. It combines data into new row groups, and compresses all row groups into columnstore. The Database Engine defragments the columnstore by physically deleting rows that have been marked as deleted. When rebuilding an index and the ONLINE option is set to ON, the underlying objects, the tables and associated indexes, are available for queries and data modification. You can also rebuild online a portion of an index residing on a single partition. Exclusive table locks are held only for a very short amount of time during the alteration process.

You can find more details about this version here

We run all kinds of Database services that vow your success