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/sql_priv.h | |
| 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/sql_priv.h')
| -rw-r--r-- | sql/sql_priv.h | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/sql_priv.h b/sql/sql_priv.h index a304cd39df7..76260ec51e7 100644 --- a/sql/sql_priv.h +++ b/sql/sql_priv.h @@ -234,6 +234,7 @@ #define OPTIMIZER_SWITCH_USE_ROWID_FILTER (1ULL << 33) #define OPTIMIZER_SWITCH_COND_PUSHDOWN_FROM_HAVING (1ULL << 34) #define OPTIMIZER_SWITCH_NOT_NULL_RANGE_SCAN (1ULL << 35) +#define OPTIMIZER_SWITCH_HASH_JOIN_CARDINALITY (1ULL << 36) #define OPTIMIZER_SWITCH_DEFAULT (OPTIMIZER_SWITCH_INDEX_MERGE | \ OPTIMIZER_SWITCH_INDEX_MERGE_UNION | \ |