Choosing Physical Tuning Options › Non-SQL Tuning Options › CALC Duplicates Option

CALC Duplicates Option

You can specify options for nonunique CALC keys indicating how these nonunique occurrences will be stored in the database. You can specify duplicates first or duplicates last .

• Duplicates first— The duplicate entity occurrence will be logically placed in the database before the entity occurrence already having that CALC key.
• Duplicates last— The duplicate entity occurrence will be logically placed in the database after the entity occurrence already having that CALC key.
• Duplicates not allowed— Duplicates not allowed in the non-SQL definition is equivalent to unique.