Join Index Checks (PDM)

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


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com