I am using the 'Compare Models' to compare a DM design against the database. When comparing a table a difference is shown up for the indexes.
The primary key of the table is shown as an index in the model imported from the database, and the is no index shown in the model from DM (which is correct).
The index in the database model should not be shown and compared.
Oracle Database enforces a
PRIMARY KEYintegrity constraint on a table by creating a unique index on the unique key or primary key. This index is automatically created by the database when the constraint is enabled.
For user named PK/UK constraint we cannot distinguish if support index is created by database or there is an index explicitly created by the user.
There are customers having explicitly created indexes in their model having the same name as PK/UK constraint. Discarding such indexes during import will discard valuable information about storage properties related to PK/UK constraint.
Support indexes for database named PK/UK constraints are discarded during import.