PowerDesigner provides default model checks to verify the validity of 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 |