Chapter 15 DBMS-Specific Features

Bitmap join indexes

A bitmap join index is a bitmap index described through a join query. It stores the rowids from one base table along with the indexed columns from the joined tables.

A bitmap join index must be defined on a single table, called base table.

For more information on bitmap join indexes, see Oracle documentation.

You can design a bitmap join index:

• Automatically, by creating bitmap join indexes from all references linked to a fact table. This can be done using the Rebuild join index feature
• Manually, by creating a bitmap join index in the list of join indexes or from the table property sheet

Copyright (C) 2006. Sybase Inc. All rights reserved.