Using secondary indexes with logical relationships

You can use secondary indexes, except for Fast Path secondary indexes, with logical relationships.

When creating or using a secondary index for a database that has logical relationships, the following restrictions exist:

• A logical child segment or a dependent of a logical child cannot be a target segment.
• A logical child cannot be used as a source segment; however, a dependent of a logical child can.
• A concatenated segment or a dependent of a concatenated segment in a logical database cannot be a target segment.
• When using logical relationships, no qualification on indexed fields is allowed in the SSA for a concatenated segment. However, an SSA for any dependent of a concatenated segment can be qualified on an indexed field.