• 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