BITMAP Index
- Used in data warehouses
- Compact; work best for columns with a small set of values
- Where repeating values arise, bitmap would be a good choice in OLAP.
- Used in data warehouses
- Compact; work best for columns with a small set of values
- Where repeating values arise, bitmap would be a good choice in OLAP.
Bitmap indexes can cause a serious locking problem in OLTP system.
An excellent video example of how Bitmap index works in Oracle -
