Bitmap index

Examples

Bitmap Index: 

CREATE BITMAP INDEX emp_bitmap_idx ON big_emp(sex);

Bitmap Join Index: 

CREATE BITMAP INDEX emp_dept_loc ON emp(dept.loc)
  FROM emp, dept
 WHERE emp.deptno = dept.deptno
 TABLESPACE index_ts1;