A Bitmap Index is a type of database index that uses bitmaps (arrays of bits) to represent the presence or absence of a value for a particular field in a database table. This index structure is particularly efficient for columns with a limited number of distinct values, known as low-cardinality columns. Bitmap indexes are commonly used in analytical databases or data warehousing environments where complex queries involving multiple dimensions and aggregation are frequent.
New to topics? Read the docs here!