I've been reading some Oracle documentation about Hash Join but I am not clear what Oracle is based on when it splits tables into partitions after full table scans. Say, if I have EMP and DEPT table, when Oracle partitions them, is it true a partition for EMP table actually corresponds to a partition for DEPT table, or it splits them simply based on the size?