Chapter 9 Working with Data Models
The following PDM model checks are made on join indexes and bitmap join indexes:
| Check | Description and Correction |
|---|---|
| Join index name and code uniqueness | Join index names and codes must be unique in the model.
Manual correction: Modify the duplicate name/code Automatic correction: Appends a number to the duplicate name/code |
| Existence of base table | Join index must have a base table.
Manual correction: Select a base table in the join index property sheet Automatic correction: None |
| Join Index tables owners | The tables associated to a join index must have the same owner.
Manual correction: Modify the join index owner or the table owner Automatic correction: None |
| Join index references connection | Join index references must be connected to selected table on a linear axis.
Manual correction: Delete or replace references in the join index Automatic correction: None |
| Duplicated join indexes | Join indexes cannot have the same set of references.
Manual correction: Delete one of the duplicated join indexes Automatic correction: None |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |