IGNORE_DUP_KEY option on index

• Joe Doe-459976

  SSC Veteran

  Points: 215

  More actions

  July 3, 2007 at 8:56 am

  #98477

  Is there a down side to setting IGNORE_DUP_KEY=ON when creating unique nonclustered index?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  October 1, 2007 at 9:50 pm

  #738001

  You might have duplicate keys 🙂

  Other than that, nothing I'm aware of.