joins vs subquery , Exists clause

Hi Tom, In terms of performane, which one is better joins or subquery ? Can you explain with an example. Also what is difference between nested loops and hash joins and how to determine which one to use from one of them for better performance...

Read More...

---