A bitmap join index is actually a precomputed join from a column in a parent table to the rows of the child table that join with rows of the parent table.

Question

Quizplus · Accepted Answer

A bitmap join index is a precomputed join in which an index is created on a column in a parent table and a bitmap is generated for each distinct value in that column. Each bitmap maps to the rows in the child table that join with the corresponding value in the parent table column. This provides a fast way to perform join operations between the parent and child tables.

A Bitmap Join Index Is Actually a Precomputed Join from a Column