4 Replies Latest reply on Aug 15, 2013 10:19 AM by HansJK

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




      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