First page Back Continue Last page Graphics
Bitmap Indexes Example
Example: Create the CUSTOMER table
GENDER column only has 2 possible values
Create a bitmap index on the GENDER column
Notes:
For the example in the slide:
The bitmap index would have a structure conceptually similar to:
M F ROWID
1 0 AAA
0 1 AbA
0 1 AAN
1 0 AAJ
This query will be assisted by the bitmap index:
SELECT * FROM customer WHERE gender = 'M';