Bitmap Join Indexes

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

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

You can design a bitmap join index either automatically or manually.

• Automatically Creating Bitmap Join Indexes Through Rebuilding
  You can automatically generate a bitmap join index for each fact table and the dimension tables that it references. Each generated bitmap join index consists of the references that link a fact table to all the dimension tables located on a single axis proceeding from the fact table.
• Manually Creating Bitmap Join Indexes
  You can manually create bitmap join indexes from the list of join indexes or via the base table property sheet.
• Bitmap Join Index Properties
  A bitmap join index has the following properties:
• Adding a Column to a Bitmap Join Index
  You can define the list of columns involved in the bitmap join index. These columns proceed from the different dimension tables linked to the base table.
• Adding a Reference to a Bitmap Join Index
  You can add a reference to any bitmap join index. You do this, for example, when you create a new reference that you want to include in an existing bitmap join index.