Inner joins vs IN/EXISTS - SQL in 60 seconds

[@IM4fLEX]

Love these informative shorts on SQL.

[@TheMagicofSQL]

Great, glad you find them useful!

[@pablolocles9382]

But doing that you won't achieve the best performance using indexes and keys. Join handles it much better, even if you don't use the other table outputs.

[@TheMagicofSQL]

Can you demonstrate a case where that happens? Oracle Database transforms IN/EXISTS into joins under the covers, so the performance of these three should be identical

[@michael.2118]

Hi