Groupby Free Sql Server Training
Columnstore Indexes: What are waiting for? by Niko Neugebauer
- Autor: Vários
- Narrador: Vários
- Editor: Podcast
- Duración: 1:18:35
- Mas informaciones
Informações:
Sinopsis
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.