You can automatically generate a join index for each selected fact table and the dimension tables that it references. Each rebuilt join index contains the references that link the fact table to all the dimension tables located on a single axis proceeding from the fact table.
A join index is constrained and can only be defined for tables that are organized in a connected tree. A reference between two fact tables does not generate any join index.
- Select to open the Rebuild Join Indexes dialog.
- On the General tab, select the appropriate mode to use:
- Delete and Rebuild - all existing indexes are deleted before join index rebuild.
- Preserve - preserves all existing join indexes
- Click the Selection tab, and select one or more fact tables from the list:
- Click OK, and then Yes to confirm the rebuild.
A join index is generated for each fact table. The generated join indexes are available in the list of join indexes (select ).
