Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Improving Analytics Performance With Columnstore Indexes

PASS Data Community Summit via YouTube

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

Reviews

Start your review of Improving Analytics Performance With Columnstore Indexes

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.