• codebyo (9/22/2011)


    I got it right because I always remember reading that the "top (outer) input" is read first and then it goes look for matches in the "bottom (inner) input". Even the Nest Loops operator works this way, right?

    Right. 🙂

    http://sqlblog.com/blogs/paul_white/archive/2010/08/05/iterators-query-plans-and-why-they-run-backwards.aspx