Sample Header Ad - 728x90

Is Oracle 10g smart enough to work on a WHERE clause identically as the equivalent INNER JOIN?

2 votes
1 answer
51 views
Way back when Michael Jackson was still alive, I made this question: https://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause And now I'm performance-auditing a system in which the developer used the first form, instead of an INNER JOIN. The DBMS is Oracle 10.2.0.4 on Solaris/SPARC. I could, of course, recommend the change in syntax solely because it's better form, but if it won't positively impact performance it's kind of pointless. So, my question is: is it possible there will be a change in query execution if I ask them to change the query syntax to INNER JOIN?
Asked by JCCyC (133 rep)
Jul 16, 2015, 08:17 PM
Last activity: Jul 16, 2015, 08:27 PM