SQL Query JOIN Performance
I wanted to know what is better performance-wise:
to put the conditions in the JOIN? (x JOIN y on x.hi = y.hi AND ....) or maybe to put it under the WHERE, and leave the JOIN only with the crossing condition.



thanks folks
SQL Query JOIN Performance
===

I wanted to know what is better performance-wise:
to put the conditions in the JOIN? (x JOIN y on x.hi = y.hi AND ....) or maybe to put it under the WHERE, and leave the JOIN only with the crossing condition.



thanks folks