In Microsoft SQL, is there any difference in performance between this:
SELECT columns FROM table1 WHERE cond
UNION
SELECT columns FROM table2 WHERE cond
and this:
SELECT columns FROM
(
SELECT columns FROM table1
UNION
SELECT columns FROM table2
) WHERE cond
?