I have recently had a lot of practice working on a large enterprise data warehouse project with over 40TB worth of data (5TB compressed), where most fact tables and many dimensions were created with CCI. I would like to share the lessons I had learned on how to load, query and manage data in Clustered Columnstore Indexes (CCI). Amongst other things you will discover the following:
- CCI for temporary tables: method or a madness?
- Patterns for CCI on dimensions
- Partitioning CCI: tips and tricks
- Data loading DOs and DON'Ts
- Data management DOs and DON'Ts
- How to make the most of your CCI
The session assumes familiarity with the CCI basics: delta-store, tuple mover, rowgroup.  Please familiarize yourself with these before coming to this session.
(no tags)
The video is not available to view online.