diff options
| author | Sergei Petrunia <sergey@mariadb.com> | 2023-03-09 17:04:07 +0300 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2023-04-28 16:24:08 +0300 |
| commit | 4329ec5d3b109cb0bcbee151b5800dc7b19d1945 (patch) | |
| tree | 4d5f099a763c0a2218b45ce93fcc777ea0ded288 /sql/sys_vars.cc | |
| parent | 2eb7bf1ec301d43a7e72b8720f6ee153dc52b6c9 (diff) | |
| download | mariadb-git-bb-10.6-mdev30812.tar.gz | |
MDEV-30812: Improve output cardinality estimates for hash joinbb-10.6-mdev30812
Introduce @@optimizer_switch flag: hash_join_cardinality
When it is on, use EITS statistics to produce tighter bounds for
hash join output cardinality.
Amended by Monty.
Reviewed by: Monty <monty@mariadb.org>
Diffstat (limited to 'sql/sys_vars.cc')
| -rw-r--r-- | sql/sys_vars.cc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/sys_vars.cc b/sql/sys_vars.cc index 2dbfe1bdeec..29cd5809ea1 100644 --- a/sql/sys_vars.cc +++ b/sql/sys_vars.cc @@ -2756,6 +2756,7 @@ export const char *optimizer_switch_names[]= "rowid_filter", "condition_pushdown_from_having", "not_null_range_scan", + "hash_join_cardinality", "default", NullS }; |