+ 4
If you are using the IN operator, the SQL engine will scan all records fetched from the inner query. On the other hand if we are using EXISTS, the SQL engine will stop the scanning process as soon as it found a match.
5th Oct 2017, 8:31 PM
Ankit Agrawal
Ankit Agrawal - avatar