RE: Optimizing UNION performance

2007-02-02 Thread Stephen the Cook
Malcolm Greene wrote: Are there any ways to optimize UNION performance - in general or with an Oracle 8.17 backend? I have 5 data sets that I need to merge via a UNION and the time to its to build each set individually is 9 secs but the time it takes to build the same set of data and

Optimizing UNION performance

2007-02-01 Thread Malcolm Greene
Are there any ways to optimize UNION performance - in general or with an Oracle 8.17 backend? I have 5 data sets that I need to merge via a UNION and the time to its to build each set individually is 9 secs but the time it takes to build the same set of data and union together into a single set

Re: Optimizing UNION performance

2007-02-01 Thread Paul Hill
On 2/1/07, Malcolm Greene [EMAIL PROTECTED] wrote: Are there any ways to optimize UNION performance - in general or with an Oracle 8.17 backend? I have 5 data sets that I need to merge via a UNION and the time to its to build each set individually is 9 secs but the time it takes to build the