First page Back Continue Last page Graphics
Creating Bitmap Join Index
Given these tables:
Bitmap created:
Notes:
The bitmap join index pre-computes the join and stores the result in a bitmap.
In our example, the bitmap index will contain all the dept.dname values and a bitmap that maps to the rowids in the EMP table. Each bit in the bitmap is translated to a ROWID that points to a row in the EMP table.