0

Possible Duplicate:
is NATURAL JOIN any better than SELECT FROM WHERE in terms of performance ?

Is there an advantage to using natural joins vs a straight where clause in terms of SQL Server performance? I don't see it, but I'm wondering what the advantage is other than separation of join logic and filtering.

Community
  • 1
  • 1
Burke Holland
  • 2,325
  • 1
  • 22
  • 33

2 Answers2

4

There is no such thing as NATURAL JOIN in SQL Server (a good thing or two)

If you mean explicit INNER JOIN syntax, then there is no performance difference

For more reasons why explicit is good, see my answer here
SQL JOIN: is there a difference between USING, ON or WHERE?

Community
  • 1
  • 1
gbn
  • 422,506
  • 82
  • 585
  • 676
0

In short no - it's down to personal preference

BonyT
  • 10,750
  • 5
  • 31
  • 52
  • Personal preference shouldn't come into it. Correctness should: http://stackoverflow.com/questions/5654278/sql-join-is-there-a-difference-between-using-on-or-where/5654338#5654338 – gbn May 23 '11 at 16:45