SQLBits 2018

Maximizing the Query Performance with Columnstore Indexes

Common performance issues with clustered columnstore index experienced by customers and strategies to address them.
Columnstore index can speed up the performance of analytics queries significantly but are you getting the best performance possible? Come to this session on to learn how to diagnose performance issues in queries accessing columnstore index and the steps you can take to troubleshoot. Some of the techniques we discuss here are rowgroup elimination, statistics, partitioning, improving the query plan quality, tweaking the schema, and creating one or more nonclustered btree indexes.