Join Indexes (Teradata)

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. Join indexes are supported for Teradata v12 and higher. 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 a package) in the Browser, and select New > Join Index.

To complete the view, specify a view query (see View Queries).

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