Similar to the NestedLoopsJoin algorithm, NestedLoopsAntisemijoin joins its inputs by scanning the right-hand side for each row of the left-hand side. As with NestedLoopsJoin, the right-hand side may be read many times, so for larger inputs an index scan is preferable. NestedLoopsAntisemijoin differs from NestedLoopsJoin in that it only outputs values from the left-hand side; the right-hand side is used only for restricting which rows of the left-hand side appear in the result. Specifically, values from the left-hand side are only included if they have no corresponding value on the right-hand side.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|