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 h