SQLBits 2023

Columnstore Index Compression in a Nutshell

Improve analytic queries by unlocking the secrets of columnstore compression!
Compression is one of the key optimizations that make columnstore indexes fast.

How does it work? What are the encoding algorithms used? What in the world is Vertipaq optimization?

This session is a speedy blast through the not-so-basic details of how columnstore indexes compress their data and how you can use that knowledge to make your analytic processes faster!