Overview
Explore the power of columnstore indexes for improving analytics performance in SQL Server in this comprehensive conference talk from PASS Data Community Summit. Dive into the architecture and benefits of columnstore indexes for storing and querying large-scale OLAP data. Learn how compression techniques and column metadata enable faster reads and efficient query processing over billions of rows. Discover the evolution of columnstore indexes from SQL Server 2012 to 2019, including new features that can significantly boost analytics workloads. Gain insights into best practices for data ordering, archive compression, and index maintenance. Examine write operations, segment elimination, and the delta store concept. Investigate nonclustered columnstore indexes and in-memory implementations to optimize your data storage and analytics capabilities.
Syllabus
Intro
Session Evaluation
OLAP Data Storage
What is a Columnstore Index?
Columnstore Index Architecture
Segment Elimination
The Delta Store
Write Operations: INSERT
Write Operations: DELETE
Best Practice: Data Order
Columnstore Archive Compression
Columnstore Index Maintenance
Nonclustered Columnstore Index
Columnstore Indexes...in memory?
Taught by
PASS Data Community Summit