Use the Relationship Index Analysis window to analyze indexes for relationships that are used with the access definition and to create indexes.
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.