| From: | Alban Hertroys <alban(at)magproductions(dot)nl> |
|---|---|
| To: | Shoaib Mir <shoaibmir(at)gmail(dot)com> |
| Cc: | Shane Ambler <pgsql(at)007marketing(dot)com>, Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to append tables in a view |
| Date: | 2007-02-13 10:18:07 |
| Message-ID: | 45D1905F.1020107@magproductions.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)magproductions(dot)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 //
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2007-02-13 11:11:33 | Re: Keyword OWNED not recognized in pg v. 8.1 |
| Previous Message | Shoaib Mir | 2007-02-13 09:55:57 | Re: How to append tables in a view |