• Very good question, and an awesome explanation. (Apart from one small type that you probably put in deliberately to prove that you're still human).

    Thanks, Tom!


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/