Segment and Rowgroup Elimination
摘要
A key component of how columnstore indexes function is that each 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, increases query speed, and improves memory-related performance metrics, such as page life expectancy.