INNER JOIN Performance in SQL

Question

INNER JOIN Performance in SQL

Navigation

#1 by (1 votes)

2

Hello, could anyone tell me if there is any significant performance difference in the two ways of doing INNER JOIN below?

Way 1:

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name=table2.column_name;

Way 2:

SELECT column_name(s)
FROM table1, table2
WHERE table1.column_name=table2.column_name;

I think the answer should depend on the DBMS, I'm more interested in Oracle databases that are the ones I use most often, but if anyone knows the answer to others it would be nice to know!

sql join oracle

asked by anonymous 17.12.2015 / 19:42

1 answer

Ion-footer-bar on the ion-list? Is it possible to validate the import of an excel file with regular expression?

score 1 · Accepted Answer

In performance, no, but in language expression, yes. Oracle recommends quitting non-ANSI operations because they are more limited than ANSI .

In addition, because ANSI syntax is a standard applicable to all databases, typing everything in ANSI facilitates portability for other databases if this is desirable in the future.