Which System Variable Tells The Optimizer To Skip Certain Plans #414
Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?
This multiple choice question (MCQ) is related to the book/course gs gs113 MySQL. It can also be found in gs gs113 Query Optimization - MySQL Query Optimizer - Quiz No.1.
Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?
optimizer_prune_level
optimizer_search_depth
optimizer_search
optimizer_prune
Similar question(s) are as followings:
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113 MySQL
Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113 MySQL
Online Quizzes