When I see something like this in an Oracle query plan:
HASH JOIN
TABLE1
TABLE2
Which of these two tables is being hashed?
The Oracle documentation refers to a "smaller" table usually being hashed, but is there a guarantee that the hashed table will always be in a particular position (either top or bottom sub-node) when displayed inside a query plan?