Whew. We started the morning with the Users table, put a columnstore index on it, and we saw that columnstore indexes have 4 benefits: Batch mode processing Read less rows (row group & segment elimination) Read less columns (especially from wide tables) Compression The more of these you use, the better a fit compression can…
09 Recap
Whew. We started the morning with the Users table, put a columnstore index on it, and we saw that columnstore indexes have 4 benefits: Batch mode processing Read less rows (row group & segment elimination) Read less columns (especially from wide tables) Compression The more of these you use, the better a fit compression can…
To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of Columnstore Indexes, or log in if you already shelled out the cash.
- 0.1 Prerequisites Before the Class
- 0.2 How to Set Up Your Own Lab Server
- 01 How Columnstore Data is Stored
- 02 How Columnstore Data is Deleted, Updated, and Inserted
- 03 How Columnstore Data Is Selected
- 04 How Columnstore Data is Rebuilt
- 05 Clustered Columnstore Quiz: Is Your Table a Good Fit?
- 06 Nonclustered Columnstore Advantages
- 07 A Better Clustered Columnstore Candidate
- 08 Partitioning Is a Great Partner for Columnstore