During query runtime, the outer reference values may change. In some situations, the values may change for only those references that are not used by the inner side of the nested loop. In these situations, the added performance spool can interpret this change incorrectly. Therefore, it returns incorrect results.
Article ID: 3068776 - Last Review: 17 Aug 2015 - Revision: 1