Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
performance question: union all with or without sub-select?
just want to add, that the WHERE statement is the same in all cases - all tables have the same scheme. -
performance question: union all with or without sub-select?
just want to add, that the WHERE statement is the same in all cases - all tables have the same scheme. -
performance question: union all with or without sub-select?
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 ... -
performance question: union all with or without sub-select?
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? SELECT ... FROM table1 WHERE ... UNION ALL SELECT ... FROM table2 WHERE ... ... ORDER BY...
