SQL Tips

2018/6/12 posted in  Database

JOIN vs EXISTS vs IN

Generally speaking JOINs are much better than EXISTS & EXISTS is better than IN, performance wise.

If your result set is small then you can use IN or EXISTS.

But if result set contains a large set of records, then use JOINS.