diff options
| author | Igor Babaev <igor@askmonty.org> | 2019-08-30 18:47:14 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2019-08-30 18:47:14 -0700 |
| commit | 9380850d874c77656d0c42cfa11bf0d187064849 (patch) | |
| tree | 5abffcd5f13bfd03089e049cb22c1b0c21c47ce0 /mysql-test/main/mysqld--help.result | |
| parent | fac81c67527605710e1cc76db6df4b8fce34b06b (diff) | |
| download | mariadb-git-9380850d874c77656d0c42cfa11bf0d187064849.tar.gz | |
MDEV-15777 Use inferred IS NOT NULL predicates in the range optimizer
This patch introduces the optimization that allows range optimizer to
consider index range scans that are built employing NOT NULL predicates
inferred from WHERE conditions and ON expressions.
The patch adds a new optimizer switch not_null_range_scan.
Diffstat (limited to 'mysql-test/main/mysqld--help.result')
| -rw-r--r-- | mysql-test/main/mysqld--help.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/mysqld--help.result b/mysql-test/main/mysqld--help.result index 3f155672fa5..056614bf791 100644 --- a/mysql-test/main/mysqld--help.result +++ b/mysql-test/main/mysqld--help.result @@ -710,7 +710,7 @@ The following specify which files/extra groups are read (specified before remain extended_keys, exists_to_in, orderby_uses_equalities, condition_pushdown_for_derived, split_materialized, condition_pushdown_for_subquery, rowid_filter, - condition_pushdown_from_having + condition_pushdown_from_having, not_null_range_scan --optimizer-trace=name Controls tracing of the Optimizer: optimizer_trace=option=val[,option=val...], where option |