A

Admin • 833K Points
Coach

Q. Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?

  • (A) optimizer_prune_level
  • (B) optimizer_search_depth
  • (C) optimizer_search
  • (D) optimizer_prune
  • Correct Answer - Option(A)
  • Views: 30
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This question is about how MySQL's query optimizer chooses the best way to execute a query. The optimizer considers different execution plans, which are like recipes for how to fetch data. To make the process faster, the optimizer sometimes skips certain plans if it thinks they are unlikely to be efficient.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.