A

Admin • 833K Points
Coach

Q. Which of the following WHERE clauses are faster?
1. WHERE col * 3 < 9
2. WHERE col < 9 / 3

  • (A) 1
  • (B) 2
  • (C) same speed
  • (D) dependent on operating system
  • Correct Answer - Option(B)
  • Views: 31
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This question is about how MySQL handles calculations in a WHERE clause. Think of it like this: MySQL wants to be as efficient as possible when searching for data.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.