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

B) optimizer_search

C) optimizer_prune_level

D) optimizer_search_depth

Correct Answer : optimizer_search_depth

Explanation : In MySQL, the optimizer_search_depth system variable tells how far into the “future” of each incomplete plan the optimizer should look to evaluate whether it should be expanded further.