Bitmap
Short Description
Bitmap filtering is used in parallel query plans to reduce data being passed up the plan
Detailed Description​
Bitmap filters are used by SQL Server to streamline data for further stages and can be seen in parallel query plans. By applying bitmap masking to incoming data, rows that can never match are rejected lower down the plan. Having less data to process higher up the plan speeds up execution.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.