Multiple choice technology databases

Which one among the following is more faster?

  1. IN

  2. EXISTS

  3. LIKE

  4. EXIST
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

EXISTS is generally faster than IN for subquery performance, especially with large datasets. EXISTS stops processing as soon as it finds a match (short-circuit evaluation), while IN may evaluate the entire list. Additionally, EXISTS handles NULL values more predictably - IN can return unexpected results when the subquery contains NULLs. Note: 'EXIST' is not valid SQL syntax.

Keep practicing — related questions