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.
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.
Copyright © 2015 Powered by MWeb, Theme used GitHub CSS.