This discussion is archived
4 Replies Latest reply: Aug 15, 2013 3:19 AM by HansJK RSS

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

HansJK Newbie
Currently Being Moderated

Hi

 

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points