Bitmap indexes are typically used for columns with low cardinality, i.e. with a small number of distinct values. This is not always the best solution. The following use case describes a situation from a real-life project and explains why and how we replaced a bitmap index with a combination of virtual column and b-tree index.
How to Replace a Bitmap Index
Reply