What is bitmap index?

A secondary file structure consisting of a column value and a bitmap. A bitmap contains one bit position for each row of a referenced table. A bitmap column index references the rows containing the column value. A bitmap join index references the rows of a child table that join with rows of the parent table containing the column. Bitmap indices work well for stable columns with few values typical of tables in a data warehouse.

Tags: Database, Education, Software

Related