SQL Server, the bitmap operator clearly explained.
Hi Guys, For this last post of March we will talk about an operator that we have seen in the execution plan . Perhaps it is less known than the others but it is worth knowing. Today we will talk about the Bitmap operator . It is used to filter data and to improve performance . As usual, I will try to be as clear as possible. Enjoy the reading! The Bitmap Operator As mentioned earlier today we will talk about the Bitmap operator. This operator is born with the aim of improving performance when we are dealing with a lot of data and the execution plan works in parallel . Let's see with an example how to generate an execution plan that contains the Bitmap operator. For the example we generate a couple of heap tables: Create table TabA (id int identity (1,1), Progr int ) Create table TabB (id int identity (1,1), Progr int ) Both tables have the same structure: a field ID of type integer and a field Progr of type integer. We will join TabA and TabB thr...