Different types of JOINs and performance

[link9]

Hello all --

Just wanted to get some input on this. There are basically two different ways to construct a query that JOINs two tables together, and I was wondering if there's any performance difference between the two:

SELECT t1.*
FROM table1 t1 INNER JOIN table2 t2 ON t1.col1 = t2.col2

-- OR --

SELECT t1.*
FROM table1 t1, table2 t2
WHERE t1.col1 = t2.col2

Personally, I use the first option, but I have seen many examples using the second, and was just curious as to if there's any real difference.

Thanks!
paul

 

[tlbroadbent]

There is a Microsoft article about the differences. As far as performance goes, there is no difference.

http://www.microsoft.com/sql/using/tips/development/July23.asp

Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com

 

[PruSQLer]

It's my understanding that regardless of how you write the query, it will be executed as :


SELECT t1.*
FROM table1 t1 INNER JOIN table2 t2 ON t1.col1 = t2.col2

so there is no difference in performance. This method is the recommended one.