INNER JOIN performance in SQL

Question

Hello, would anyone know me if there is any significant difference in performance 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 banks that are the ones I use most often, but if someone knows the answer to others it would also be nice to know!

Answer 1

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

Also, since ANSI syntax is a standard applicable to all databases, writing everything in ANSI makes it easy to port to other databases if this is desirable in the future.