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