Answer:
EXISTS is efficient as if any row returned, Search stops.
IN is looking for a specific match which takes longer.
However they may not always replace each other but wherever they can, above is their efficiency comparison !!
Asked In: Many Interviews |
Alert Moderator