Search code examples
sqldatabasejoinsubquerycorrelated-subquery

correlated query /subquery VS join query

can we always convert a usual subquery/correlated subquery to join type query?

Solution

  • yes and no...

    • Yes, in that JOIN/EXISTS/IN usually give the same plan and are often the same

    • No, in that if the EXISTS table has > 1 row for the main table you'll need DISTINCT to avoid dupes

    I'd stick with an EXISTS type query if this is relevant and you don't need data from the EXISTS table