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.
In the first part of this series, we saw how the Halloween Problem applies to UPDATE queries. In this post, we will see how the same underlying issue can affect INSERT and DELETE statements.