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_10

10. Segment and Rowgroup Elimination

Edward Pollack¹  

(1)

Albany, NY, USA

 

A key component to how columnstore indexes function is that every segment within the index is its own building block. Each may be read individually or in groups, but the number of segments read via any query can be reduced by efficient architecture and optimal query patterns. Reducing segments read directly reduces IO, improves query speed and memory-related performance metrics, such as page life expectancy.

Segment Elimination

Each segment represents data for a ...