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.

A reference between two fact tables does not generate any bitmap join index. A bitmap join index is constrained and can only be defined for tables that are organized in a connected tree.

Select Tools > Rebuild Objects > Rebuild Join Indexes to open the Rebuild Join Indexes dialog box, and select one of the following modes:
- Delete and Rebuild - all existing indexes are deleted before join index rebuild.
- Preserve - preserves all existing join indexes in the PDM.
Click the Selection tab, select one or more fact tables in the list, and then click OK.

A confirmation box asks if you want to continue.
Click Yes to generate a bitmap join index for each fact table.

Note:
Automatically generated bitmap join indexes appear in the list of join indexes. To display the list, select Model > Join Indexes.