πŸ“Š MySQL
Q. Which system variable tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further?
  • (A) optimizer_prune_level
  • (B) optimizer_search_depth
  • (C) optimizer_search
  • (D) optimizer_prune
πŸ’¬ Discuss
βœ… Correct Answer: (B) optimizer_search_depth

Explanation: This question is about how MySQL's query optimizer decides how much time to spend searching for the best way to execute a query.

Explanation by: Ritu Singhal
This question is about how MySQL's query optimizer decides how much time to spend searching for the best way to execute a query.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
66
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Ritu Singhal
Publisher
πŸ“ˆ
94%
Success Rate