1

Is there any performance difference between these two query. Both query returns the same result.

select * from tbl_a, tbl_b

and

select * from tbl_a INNER JOIN tbl_b
S S
  • 1,443
  • 2
  • 12
  • 42

1 Answers1

1

There is a thread already touching on this topic. Check it out:

What is the difference between inner join and outer join

Performance wise, it will all come down to the amount of data you're working with. A couple tables with a few hundred rows won't make a dent, but you will notice a difference as the amount of data sorted grows.

Good luck!

Community
  • 1
  • 1