Tag Archives: hash join

Hash join in Oracle with example

Hash join in Oracle

Last updated on September 18th, 2016 at 08:09 amWhat 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 is called … Continue reading Hash join in Oracle with example »

Various Joins Method in Oracle

Last updated on September 15th, 2016 at 05:24 amPerformance 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 type transactions … Continue reading Various Joins Method in Oracle »