Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

E. PollackAnalytics Optimization with Columnstore Indexes in Microsoft SQL Serverhttps://doi.org/10.1007/978-1-4842-8048-5_12

12. Nonclustered Columnstore Indexes on Rowstore Tables

Edward Pollack¹  

(1)

Albany, NY, USA

 

Clustered columnstore indexes provide a primary storage mechanism for analytic data. For tables that are intended for use as OLAP data sources, this is the optimal choice and will provide a data structure that facilitates fast and efficient reads and writes against analytic data.

For tables that are primarily transactional in nature, but also have analytic queries executed against them, a clustered columnstore index is not appropriate. There ...