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 […]
hash join
Various Joins Method in Oracle
Performance is key for OLTP system and we should have good information about Joins Method in Oracle to increase performance for sql queries Here are the Joins Method in Oracle available in Oracle database Nested Loops -For each row in the first row source access all the rows from the second row source. -Best for OLTP […]
