UNION or UNION ALL - which faster

From: my <mohamed.yusuf_at_sympatico.ca>
Date: Sat, 25 Mar 2000 13:38:42 GMT
Message-ID: <Cj3D4.8701$n03.403288_at_news20.bellglobal.com>

[Quoted] hi everybody,

[Quoted] [Quoted] I'm hitting 5 tables with millions of records using operator UNION or UNION [Quoted] ALL. both takes hrs to get the result - I'm not worried since UNION ALL returns dublicates as well. Can anybody tell me the best way or alternative [Quoted] ways that makes faster. Received on Sat Mar 25 2000 - 14:38:42 CET

This message: [ Message body ]
Next message: Paul Beardsell: "Change Control / RCS / PVCS"
Previous message: Sybrand Bakker: "Re: Tool for calculating kernes parameters?"
Next in thread: Gerd Kock: "Re: UNION or UNION ALL - which faster"
Reply: Gerd Kock: "Re: UNION or UNION ALL - which faster"
Reply: Russ Fleming: "Re: UNION or UNION ALL - which faster"
Reply: Patrick Hamou: "Re: UNION or UNION ALL - which faster"
Reply: Antonio Sant: "Re: UNION or UNION ALL - which faster"

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

Original text of this message