Re: UNION or UNION ALL - which faster

From: Russ Fleming <rfleming_at_jaredgroup.com>
Date: Sat, 25 Mar 2000 20:34:14 GMT
Message-ID: <ap9D4.1$Hr4.1320_at_news1.onlynews.com>

UNION ALL is not supposed to reconcile its result set with other result sets in the union so theoretically it
is supposed to be faster than UNION.

If your relying on UNION to eliminate the dups perhaps you should look more closely at the sql design. Received on Sat Mar 25 2000 - 21:34:14 CET

This message: [ Message body ]
Next message: Gerald Berkovics: "IIS 4.0 asp - Oracle 8 Problem"
Previous message: Lizzie: "Oracle Reports on AIX"
In reply to: my: "UNION or UNION ALL - which faster"
Next in thread: Patrick Hamou: "Re: UNION or UNION ALL - which faster"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message