What is hash Join in Oracle? Hash joins are used when the joining large tables or when the joins requires most of the joined tables rows. This is used for equality joins only Algorithm for Oracle Hash Join 1) The optimizer uses smaller of the 2 tables to build a hash table in memory.Small table […]
Techgoeasy
Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
