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.
Presented by Sunil Aagrwal at SQLBits XVII
MP4 Video Low 474 MB
MP4 Video Med 875 MB
MP4 Video High 1,363 MB
MP4 Video HD 2,579 MB