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
[EMAIL PROTECTED]
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 //
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
