Analyzing relationship indexes

Use the Relationship Index Analysis window to analyze indexes for relationships that are used with the access definition and to create indexes.

The Relationship Index Analysis window lists each relationship in the Access Definition, with an analysis of indexes for the corresponding parent and child tables. The window lists the following index statuses for the parent and child table columns in each relationship:
None
Necessary indexes do not exist.
Partial
Necessary indexes for some relationship columns exist.
Full
Necessary indexes for all relationship columns exist.
Indeterminate
Optim attempted to create DBMS indexes. Click Refresh to analyze the new index.
Not Analyzed
No indexes are needed.

If the analysis determines that the parent or a child table requires an index to increase the efficiency of processing, the Needed check box is selected. If the Needed check box is not selected, the index was not analyzed or is not needed.

You cannot create an index for an expression in a relationship that is not a column name (a concatenation, literal, or substring). If a relationship includes an expression that is not a column name, only the column name expressions that precede the non-column name expression can be indexed.

New index names use the following format: the identifier (creator ID, owner ID, or schema name), the letter I, the first eight letters of the table name, and an eight-digit number. For example: identifier.I_tablenamnnnnnnnn.

  1. Expand the folder in the Directory Explorer that contains the access definition, expand the Access Definitions node, and double-click the access definition. The Access Definition Editor opens.
  2. Select the Relationships tab.
  3. Click Index Analysis. The Relationship Index Analysis window opens.
  4. If the status of an index is Partial or None, complete the following steps to create an index:
    1. Right-click the relationship, and select one of the following options:
      Create all indexes > data store alias name
      Create indexes for tables in the relationship within the data store alias.
      Create indexes > Parent | Child| Both
      Create indexes for the parent table, child table, or both if the tables are in the same data store alias.
      The Review Index SQL window opens.
    2. Review and edit the SQL create index statement.
    3. Click Proceed to create the index.
  5. To review a relationship, complete the following step:
    1. Select the relationship and click Open Relationship. The Relationship Editor opens and displays the relationship.
  6. Save the access definition.


Feedback