-2

Is there any performance - difference between inner join and simple join? i.e. does either of them have a better execution plan and/or execution time? And will both these approaches always yield same result sets?

Abk
  • 87
  • 2
  • 12
  • Probably none, but you need to specify which database. Then soneone can tell you how to read the execution plans. – Jonathan Allen Jun 13 '14 at 02:58
  • Oh, and some sample SQL to show the two queries you are looking at wouldn't hurt either. I suspect they are literally the same, like `x++` vs `x=x+1`. – Jonathan Allen Jun 13 '14 at 02:59

1 Answers1

6

JOIN with no qualifier is just an abbreviation for INNER JOIN, they are exactly the same. If any database had a performance difference, I would report it as a bug.

Barmar
  • 741,623
  • 53
  • 500
  • 612