Index Checks (PDM)

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

Check

Description and Correction

Index name and code uniqueness

Depending on the DBMS, a model or a table cannot contain two indexes with identical name and/or code.

Manual correction: Modify the duplicate name/code

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

Index code maximum length

The index code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the Objects > Index category) or in the naming conventions of the model options.

Manual correction: Modify the index code length to meet this requirement

Automatic correction: Truncates the index code length to the maximum length specified in the DBMS definition

Existence of index column

An index must have at least one index column.

Manual correction: Add an index column from the Column tab of the index property sheet or delete the index

Automatic correction: Deletes the index without column

Undefined index type

An index type must be specified.

Manual correction: Specify a type in the index property sheet or delete the index with no type

Automatic correction: None

Index column count

The current DBMS does not support more than the number of index columns specified in the MaxColIndex entry of the current DBMS.

Manual correction: Delete one or more columns in the index property sheet. You can create additional indexes for these columns

Automatic correction: None

Uniqueness forbidden for HNG index type

An index of HNG (HighNonGroup) type cannot be unique.

Manual correction: Change the index type or set the index as non unique

Automatic correction: None

Index inclusion

An index should not include another index.

Manual correction: Delete the index that includes an existing index

Automatic correction: None