A clustered columnstore index (CCI) is usually the best choice providing optimal query performance for almost large tables. I am using columnstore indexes since SQL 2012 and have written several articles. I will demonstrate real time life scenarios of using CCI to store analytic data efficiently like: analytics, data science, experiments results, DW, logging & Audit, reporting and analytics. Real- time analytics on OLTP be done with CCI indexes. By default, Synapse Analytics creates a CCI. I will Cover
• Batch & Row Execution and using query store to check performance
• Delete and Update Operations
• Bulk Loading Data
• Segment and Rowgroup Elimination
• Partitioning
• Nonclustered Columnstore Indexes on Rowstore Tables
• Nonclustered Rowstore Indexes on Columnstore Tables
• Maintenance & Performance
• Columnstore Indexes on Temporary Tables & Memory-Optimized tables
SQL 2022 new features : Columnstore and Batch Mode Improvements:
• Ordered Clustered Columnstore Index
• Columnstore String Improvements
• Vector Extension to Improve Batch Mode
• Columnstore Segment Elimination Enhancements
This is a demo session only with minimum theory & lessons from the fields!
https://www.youtube.com/watch?v=BKsngBKCfNA