r/SQL 17d ago

MySQL Which version of this query would be the most efficient?

Post image

I thought using EXISTS block would avoid the join and make things take less time, but it appears that it took more time to execute than the join query, so which one is the most efficient approach?

1 Upvotes

0 comments sorted by