title: Is there an alternative to joins to increase performance?
body: <p>Is there an alternative to joins to increase performance?</p>
  
  <p>Edit (gbn): related to <a href="https://stackoverflow.com/questions/3305891">join-or-correlated-subquery-with-exists-clause-which-one-is-better</a></p>
  
  <hr>
  
  <p>Why didn't anyone mention about nested loop joins?</p>