Index and View Index Checks (PDM)

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

Check

Description and Correction

Name/Code contains terms not in glossary

[if glossary enabled] Names and codes must contain only approved terms drawn from the glossary.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - None.

Name/Code contains synonyms of glossary terms

[if glossary enabled] Names and codes must not contain synonyms of glossary terms.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - Replaces synonyms with their associated glossary terms.

Name/Code uniqueness

Object names must be unique in the namespace.
  • Manual correction - Modify the duplicate name or code.
  • Automatic correction - Appends a number to the duplicate name or 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

[indexes] 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

[indexes] 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