First page Back Continue Last page Graphics

Using the Bitmap Join Idx

Notes:

The optimizer’s plan that was chosen for the query in the example shows its usage of the EMP_DEPT_BIDX bitmap join index. The query returns the number of employees in the ‘SALES’ department by using the bitmap join index.

Remember, the index definition looked like:

CREATE BITMAP INDEX emp_dept_bidx ON emp( d.dname )
FROM emp e, dept d
WHERE e.deptno = d.deptno;