Toad World® Forums

Joins - Traditional or Ansi


When joining tables in oracle is it preferred to use the traditional approach:

a.field1, b.field2
table1 a, table2 b
where =

or the Ansi standard approach:

a.field1, b.field2
table1 a
inner join
table2 b
on =

I’m new to oracle but I’ve used sql server a decent amount. I prefer the Ansi Standard but I was wondering what the preferred method is for oracle databases.



For Oracle optimizer it does not really matter.

There are few specific things you can write more easily using the ANSI, for example an outer join query with a filter condition applied to the smaller table at the same time, but ultimately there’s no difference in the traditional vs ANSI query performance.