Can any one please explain me when optimizer will go for nested loop join and hash join in oracle. I did some investigation on this If there is no index on inner table it is going for hash join. If index is there on inner table it will go for nested loop join. Can anyone please correct me on this.
2) If one table is small and another table is big it will go for nested loop join and table size are equal it will go for hash join in oracle.
Can anyone please correct me on both these points.
Thanks in advance.