What are the features of Bitmap indexes? What are the advantages and disadvantages of Bitmap indexes? Let's look at the example of Bitmap scanning. QUERYPLAN items ------------- BitmapHeapScanonbit
What are the features of Bitmap indexes? What are the advantages and disadvantages of Bitmap indexes? Let's look at the example of Bitmap scanning. Query plan items ------------------- Bitmap Heap Scan on bit
What are the features of Bitmap indexes?
What are the advantages and disadvantages of Bitmap indexes?
Let's look at the example of Bitmap scanning.
Query plan items ------------------- Bitmap Heap Scan on bitmap_test (cost = 2023. 16 .. 4157.75 rows = 99967 width = 4) (actual time = 24. 373 .. 41.054 rows = 100000 loop s = 1) Recheck Cond: (is_visible = 'yes': bpchar)-> Bitmap Index Scan on idx_bitmap_is_visible (cost = 0. 00 .. 1998.17 rows = 99967 width = 0) (actual time = 24. 252 .. 24.252 ro ws = 100000 loops = 1) Index Cond: (is_visible = 'yes': bpchar) Total runtime: 47.175 MS (5 rows) Time: 47.725 MS