Creating a Bitmap Index

Bitmap indexes are typically used in data warehouses. Data warehouses are databases containing very large amounts of data. The following statement creates a bitmap index on the ename column of the emp table:

CREATE BITMAP INDEX i_ename ON emp(ename);

1. Creating a B-tree Index
2. Composite Index
3. Retrieving Information on Indexes
4. Modifying an Index
5. Dropping an Index
6. Creating a Bitmap Index