SentryOne Team Blog (blogs.sentryone.com)

Tag : ignore_dup_key

Paul White : IGNORE_DUP_KEY slower on clustered indexes

Paul White : IGNORE_DUP_KEY slower on clustered indexes

Paul White explains why the IGNORE_DUP_KEY index option on a clustered index can result in much poorer performance than for a nonclustered unique index.