Hugo Kornelis (5/7/2010)
I would have liked the question (a lot!) if the question had asked for the logical processing order. But the question specificallly asked aboout the sequence internally used, and that threw me off completely.
Hmmm it seems my brain substituted the word 'internally' for 'logically' without conscious intervention - I had to go back and re-read the question to see that you are right about this. You have a good point.
I still think it's a great question though 😛
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi