Search notes:

Oracle SQL Plan operation HASH JOIN

See also

The plan operations HASH JOIN also fills the plan_table column access_predicates with a value.
Plan operations
Hash joins

Index