Join Indexes

Join indexes are materialized views that improve access times for cross-table queries, and which are automatically updated when changed are made to the underlying tables. PowerDesigner models join indexes as views with a stereotype of <<JoinIndex>>.

Creating a Join Index

You can create a join index in any of the following ways:

Select Model > Join Indexes to access the List of Join Indexes, and click the Add a Row tool.
Right-click the model or package in the Browser, and select New > Join Index.

Join Index Properties

You can modify an object's properties from its property sheet. To open a join index property sheet, double-click its diagram symbol or its Browser entry in the Join Indexes folder.

The following extended attributes are available on the General tab:

Name	Description
Fallback	Specifies that the join index uses fallback protection. Scripting name: Fallback
Checksum	Enables a table-specific disk I/O integrity checksum level. The checksum setting applies to primary data rows, fallback data rows, and all secondary index rows for the index. Scripting name: Checksum

Name

Description

Fallback

Specifies that the join index uses fallback protection.

Scripting name: Fallback

Checksum

Enables a table-specific disk I/O integrity checksum level. The checksum setting applies to primary data rows, fallback data rows, and all secondary index rows for the index.

Scripting name: Checksum