Originally posted by Shestakov
Both subquery independently don't use any addition sorting.
Bot if u try to get intersection of the queries, Oracle has to execute addition step for each of them:
SORT UNIQUE
This is reason, why intersection more slowly, then two subqueries
separately.
Given the number of rows involved, i don't believe that this explains the differencein execution time.