union, minus, intersect

Database
Highlighted
Enthusiast

union, minus, intersect

hi forum guru,
could you please explain how does processing of union, minus, intersect differ from join operations or sub query operation in terms of spool usage, transient journal implementation, execution time. could u plz explain how does the internal processing of set operators differ from join operators like for ex join operatro and sub query operator uses merge join, product join, nested join, hash join internally. could u plz explain how internal processing for union, minus, intersect goes about.plz guide us in which scenarios set operator will out perform join operator.
any help on this topic is highly appreciated.

Regards,
Prakhar Agarwal
2 REPLIES
Enthusiast

Re: union, minus, intersect

Hi Forum Beings,
Pls reply ....already 4 days gone since last post.
Enthusiast

Re: union, minus, intersect

You might try asking a more specific question.