Search

Home > GroupBy – Free SQL Server Training > Columnstore Indexes: What are waiting for? by Niko Neugebauer
Podcast: GroupBy – Free SQL Server Training
Episode:

Columnstore Indexes: What are waiting for? by Niko Neugebauer

Category: Technology
Duration: 01:18:35
Publish Date: 2019-02-05 05:00:00
Description:

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.

Total Play: 0