six I think that in first question you've got shared variable between outer question and subquery, so For each and every row in major query, subquery executes but in second one the subquery only executes a person time and this way performance improved. I am thinking indexes - If I had been to hurry up selects on The one tables I would probably pla