Vidyalelo
MySQL · Q535

MySQL

Programming · MySQL · question 535

Q535

The optimizer_prune_level is set by default.

A.
True
Answer
B.
False

Answer: Option A

Solution

Answer: Option A
Solution:
This question asks about the optimizer_prune_level setting in MySQL.

optimizer_prune_level is a setting that controls how aggressively the MySQL optimizer tries to simplify queries.

The question is: Is optimizer_prune_level set by default?

The answer is False.

optimizer_prune_level is not set by default. You need to explicitly set this variable if you want to use it.