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 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 |