SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Foreign Key Indexes - Auto create causing logically 'duplicate' indexes

HansJKAug 13 2013 — edited Aug 15 2013

Using DM 3.3.

We use DM with the preference set to auto create indexes for PK, UK & FK constraints. This works fine in most cases.

The scenario we have is that we have a table where the foreign key column is part of a unique constraint on that table. This leads to the creation of two indexes, the one for the unique constraint and the other for the foreign key constraint.

Is it possible at all to somehow tell DM that it can skip the creation of this specific FK index since it will be satisfied by the UK index?

Thank you & Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 12 2013

Added on Aug 13 2013

#data-modeler

4 comments

475 views