Join Index Checks (PDM)

PowerDesigner provides default model checks to verify the validity of join indexes and bitmap join indexes.

Check

Description and Correction

Join index name and code uniqueness

Join index names and codes must be unique in the model.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Existence of base table

Join index must have a base table.

Manual correction: Select a base table in the join index property sheet

Automatic correction: None

Join Index tables owners

The tables associated to a join index must have the same owner.

Manual correction: Modify the join index owner or the table owner

Automatic correction: None

Join index references connection

Join index references must be connected to selected table on a linear axis.

Manual correction: Delete or replace references in the join index

Automatic correction: None

Duplicated join indexes

Join indexes cannot have the same set of references.

Manual correction: Delete one of the duplicated join indexes

Automatic correction: None