Oracle SQL Plan operation SORT UNIQUE

HASH UNIQUE

SORT UNIQUE NOSORT

SORT UNIQUE is used for SQL statements that involve union (See plan operator UNION-ALL).

Others SQL plan operators

_gby_hash_aggregation_enabled