Chapter 15 DBMS-Specific Features

Bitmap join indexes

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

A bitmap join index is defined on a single table, called the base table.

For more information about bitmap join indexes, see your Oracle documentation.

You can design a bitmap join index:

• Automatically, by creating bitmap join indexes from all references linked to a fact table through the Rebuild join index command
• Manually, by creating a bitmap join index in the list of join indexes or from a table property sheet

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