Shoaib Mir wrote:
> So hmm a UNION with an ORDERY BY should be good for this scenario...
Only if the order matters to the OP, but he can always perform an ORDER
BY on the queries on his view. I don't really see the point.
The main difference between UNION and UINION ALL is that the latter
allows for duplicates, which removes the need to unduplicate the results
of the UNION (which requires ordering and is therefore relatively
expensive).
In short; if duplicates don't matter (or are desirtable even) UNION ALL
is faster.
--
Alban Hertroys
alban@magproductions.nl
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //
