optimizer_extra_pruning_depth
This page is part of MariaDB's Documentation.
The parent of this page is: System Variables for MariaDB Enterprise Server
Topics on this page:
Overview
In 11.4 ES:
If the optimizer needs to enumerate join prefix of this size or larger, then it will try aggressively prune away the search space.
DETAILS
PARAMETERS
Command-line | --optimizer_extra_pruning_depth=# |
Configuration file | Supported |
Dynamic | Yes |
Scope | Global, Session |
Data Type | BIGINT UNSIGNED |
Minimum Value | 0 |
Maximum Value | 62 |
Product Default Value | 8 |