Every time you see a Columnstore Index getting involved in the execution plan, do you realize 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.

Rss
Podden och tillhörande omslagsbild på den här sidan tillhör Brent Ozar. Innehållet i podden är skapat av Brent Ozar och inte av, eller tillsammans med, Poddtoppen.