Databases Reference
In-Depth Information
5.
Create a
BITMAP
INDEX
on some columns:
CREATE BITMAP INDEX BIX_GENDER_MARITAL_YOB
ON MYCUSTOMERS
(CUST_GENDER, CUST_MARITAL_STATUS, CUST_YEAR_OF_BIRTH);
6. Execute the same queries as in step 3 and compare the results.
7. In the next screenshot, we can see the results for the first query executed, after
the bitmap index creation:
8.
Drop the table:
DROP TABLE MYCUSTOMERS;
How it works...
We have created a table with some data in it. We have executed six queries in this table, using
a different predicate combination on the fields
CUST_MARITAL_STATUS
,
CUST_GENDER
, and
CUST_YEAR_OF_BIRTH
, with equality and range conditions.
