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