performance question: union all with or without sub-select?

[mbrenner]

i'm using a sqlite database and have to query similar fields spread across 3-5 tables, so in other words, the schema of the tables are the same.

now, what you guys think is faster, more performant in general?


SELECT ... FROM table1 WHERE ...
UNION ALL
SELECT ... FROM table2 WHERE ...
...
ORDER BY ...;


or


SELECT ... FROM
(SELECT * FROM table1 UNION ALL SELECT * FROM table2 ...)
WHERE ...
ORDER BY ...;


thanks

 

[mbrenner]

just want to add, that the WHERE statement is the same in all cases - all tables have the same scheme.

 

[TonyGroves]

This topic has already been posted, and is being dealt with, in the ANSI SQL forum.