We should add two more hints: HASH_JOIN and SORTED_MERGE_JOIN which will override the default decision for which join algorithm will be used.