If the quiz in the last module gave you bad news about whether clustered columnstore indexes are a good fit for your tables, take heart. Clustered columnstore isn’t the only way to make your queries go faster: there are also nonclustered columnstore indexes. In this session, we’ll look at the pros & cons of those.
06 Nonclustered Columnstore Advantages
If the quiz in the last module gave you bad news about whether clustered columnstore indexes are a good fit for your tables, take heart. Clustered columnstore isn’t the only way to make your queries go faster: there are also nonclustered columnstore indexes. In this session, we’ll look at the pros & cons of those.
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?
- 07 A Better Clustered Columnstore Candidate
- 08 Partitioning Is a Great Partner for Columnstore
- 09 Recap