Every time you see a Columnstore Index getting involved in the execution plan, do you realise that there are whole execution plans behind those Index Scans ? Did you ever ask yourself, what are those strange and weird HT_* waits stand for ? Why do we wait for seconds/minutes for something like HTBUILD while it seems that nothing happens ?

Why do we have a ROWGROUP_VERSION wait on one server, while the other allows queries to run faster ?This session focuses on answering those question – to help you understand the reasons and the conditions behind every single available wait for the Columnstore Indexes and the Batch Execution Mode.
(no tags)
The video is not available to view online.