dunnjoe (9/4/2008)
Chris,Doesn't the second solution have to do the same B-tree traversal?
Good question, today, and good discussions!!
Joe
Hi Joe,
yes it does.
I assume I have not cleared the table between my tests.
Therefore, the first option was obviously more cost efficient
in the actual plan, since the insert was not applied due to the
customer being already in the table.
I have adjusted my post above to remove the wrong information.
Best Regards,
Chris Büttner