Grant Fritchey (7/27/2015)
It tries to filter the information as it retrieves it, rather than put all the information together all at once and then filter it.
[font="Verdana"]Great assistance!
Meanwhile i would share some background of this question. FYI only.
That in WHERE (with multiple AND clauses) clause some tables are even used with IN Clause.
Those tables were changed to join statements (in FROM query joins), but query performance downgraded due to all technical scenarios behind.
Thank You, Again![/font]