![[assets/ex_bitmapandbitmapor.png|256]] - **Description**: Combines multiple bitmap index scans using a logical expressions - **Performance**: Combines bitmap index scans efficiently. - **Factors**: Number of bitmaps, bitmap scan selectivity. - **Cost**: Sum of bitmap scan costs + `cpu_operator_cost * number of bitmaps` - ![[assets/ex_bmp_and.svg|200x200]] ![[assets/ex_bmp_or.svg|200x200]] - **Operates on**: [[Structures/Index|Index]] - **Workloads**: - [[Workloads/LWLock]] - [[Workloads/Sub/SharedTidBitmap]] - [[Workloads/Sub/BufferContent]] - [[Workloads/IPC]] - [[Workloads/Sub/ParallelBitmapScan]]