Chapter 15 DBMS-Specific Features

Rebuild join indexes for all references linked to a fact table

You can automatically generate a join index for each selected fact table and the dimension tables that it references. The rebuild process only applies to fact tables selected in the Selection tab of the Join Index Rebuild tab.

Each automatically generated 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 join index.

A join index is constrained and can only be defined for tables that are organized in a connected tree.

Parameter Result of selection
Delete and Rebuild When selected all existing indexes are deleted before join index rebuild.
Preserve When selected, preserves all existing join indexes in the PDM.

The same feature applies to Oracle bitmap join indexes.

For more information on Oracle bitmap join indexes, see section Rebuild bitmap join indexes for all references linked to a fact table.

Steps To rebuild join indexes for all references linked to a fact table:

  1. Select Tools→Rebuild Objects→Rebuild Join Indexes.

    The Rebuild Join Indexes dialog box is displayed.
  2. Click the Selection tab.

    The Selection tab is displayed.
  3. Select one or more fact tables from the list.
  4. Click OK.

    A confirmation box asks if you want to continue.
  5. Click Yes.

    A join index is automatically generated for each fact table.

    Note   Displaying automatically generated join indexes
    Automatically generated join indexes appear in the list of join indexes. To display the list, select Model→ Join Indexes.


 

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