IGNORE_DUP_KEY slower on clustered indexes
SQL Performance
APRIL 5, 2019
The IGNORE_DUP_KEY option for unique indexes specifies how SQL Server responds to an attempt to INSERT duplicate values: It only applies to tables (not views) and only to inserts. The size of the performance difference depends on how many uniqueness violations are encountered during the INSERT operation. The trade-off.
Let's personalize your content