Performance using oracle SET operators

[kaushik.nandy]

Hi,

(A-B) UNION (B- A)

Here A and B are tables with 50 millions records each.

If this query operation has the worst performance , then is there any better way to get the same results ?
Assume all the table are indexed and partioned on key value.

Regards,
Kaushik Nandy

[Tim...]

Hi.

The question is too vague. Here are some thoughts.

1) If the point of this is to make sure all records are returned because you are using OUTER JOINS, then maybe you need a FULL OUTER JOIN, rather than a UNION of two LEFT OUTER JOINs.

2) If you don't care about duplicates, the UNION ALL will be quicker than the UNION because the removal of duplicates requires extra work and sorts.

Cheers

Tim...