Hi,
Your example shows that the insert with IGNORE_DUP_KEY = ON produces a much more complicated query plan because it needs to filter out the duplicates before performing the insert. This also introduces an extra Key Range Lock as seen in sp_lock.
Hi,
Your example shows that the insert with IGNORE_DUP_KEY = ON produces a much more complicated query plan because it needs to filter out the duplicates before performing the insert. This also introduces an extra Key Range Lock as seen in sp_lock.
