IGNORE_DUP_KEY slower on clustered indexes

(Paul White) 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

Register to Read