Q. Which statement is used to verify optimizer operation?

  • (A) ANALYZE
  • (B) VERIFY
  • (C) EXPLAIN
  • (D) SHOW
πŸ’¬ Discuss
βœ… Correct Answer: (C) EXPLAIN
Explanation: This question is about how we can check how MySQL plans to execute a query. Imagine you have a task to do, you might plan out the best way to complete it, right? MySQL does the same thing for your queries!
Explanation by: Sandhya Thakur
This question is about how we can check how MySQL plans to execute a query. Imagine you have a task to do, you might plan out the best way to complete it, right? MySQL does the same thing for your queries!

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
78
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Sandhya Thakur
Publisher
πŸ“ˆ
99%
Success Rate