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
πŸ’¬ Discuss
βœ… Correct Answer: (B) 2
Explanation: 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.
Explanation by: Neelam Mittal
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.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
115
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Neelam Mittal
Publisher
πŸ“ˆ
86%
Success Rate