View Index Checks (PDM)

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

Check

Description and Correction

Index name and code uniqueness

Depending on the DBMS, a model or a view cannot contain two view 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 view 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 view index code length to meet this requirement

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

Existence of index column

A view index must have at least one index column.

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

Automatic correction: Deletes the view index without column

Index column count

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

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

Automatic correction: None

View index inclusion

A view index should not include another index.

Manual correction: Delete the view index that includes an existing index

Automatic correction: None