|
The RowReplicate algorithm is used during the execution of set operations such as EXCEPT ALL and INTERSECT ALL. It is a feature of such operations that the number of rows in the result set is explicitly related to the number of rows in the two sets being operated on. The RowReplicate algorithm ensures that the number of rows in the result set is correct.
For more information, see Performing set operations on query results with UNION, INTERSECT, and EXCEPT.