Multiple choice technology databases

The query performance increases by using NOT operator.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The NOT operator typically degrades query performance because it prevents efficient index usage and often requires scanning more rows. Query optimizers struggle to use indexes effectively with NOT conditions. Optimized queries avoid NOT and use equivalent positive conditions instead.

Keep practicing — related questions