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?
β
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.