Bitmap Join Indexes (Oracle)

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. You can design a bitmap join index either automatically or manually. For detailed information about bitmap join indexes, see your Oracle documentation.

• 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: