Batch Mode Bitmaps in SQL Server
SQL Performance
AUGUST 23, 2019
In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. Background. The Query Optimizer. Bitmap Choice.
Let's personalize your content