Oracle9i for data warehousing

<Blue, <rowid>, 1000100100010010100>

<Green, <rowid>, 0001010000100100000>

<Red, <rowid>, 0100000011000001001>

<Yellow, <rowid>, 0010001000001000010>

Structure of a bitmap index

Separate ‘bitmap’ created for each value of the color column

A high-level b-tree structure is created so that each bitmap can be located

CREATE BITMAP INDEX PROD_COLOR ON PROD(COLOR)

Bitmap indexes introduction