Chapter 9 Working with Data Models
The following PDM model checks are made on 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 |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |