Detailed Notes on Join fast
6 I believe in initially question you've got shared variable concerning outer question and subquery, so For each and every row in key query, subquery executes but in 2nd 1 the subquery only executes one particular time which way overall performance enhanced.
I am thinking indexes - If I had been to