Re: Query using Union: performance

Posted in 1996

Kerry Sainsbury — Tue, 13 Aug 1996 22:22:54 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <Dvwr72.LAt@eskimo.com>, cseoanem@wport.com (Carlos Seoane) wrote: >Hi, >I want to retrieve information from two identical tables, one is >current info and the other one has historical information. I am doing >a query of both tables using a UNION, with two identical SELECT, but >refering each one to a different table. >My question is: what about the performance?. Is there a better way to >do this?. Do you mean UNION or UNION ALL? I always imagine a UNION ALL to be pretty efficient. ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.5 June 96 Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/ New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/