HI All ,
1) Can any one please post a sample when and where hash join , Merge Join and Nested Loop joins come into picture ?
2) Logical joins : Inner Join , Outer , Full , Cross joins
Physical Joins : Merge ,Hash , Nested Loop Joins
What are the differences between Logical and Physical joins ?
When should we go with Physical joins ?
It would really be appreciated if any one can post few samples .
Thanks in Advance .
View Complete Post