diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2019-10-07 23:07:16 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2020-02-09 20:41:05 +0530 |
| commit | 87f7097c4b7245f1ba8a4127f76cb9bdc702eb66 (patch) | |
| tree | fddfdb74161cbd49e9c411f25cd6f3f08d1a1001 /mysql-test | |
| parent | d539aaffa7f14cfb9e45424e0a36cc3ec870314f (diff) | |
| download | mariadb-git-87f7097c4b7245f1ba8a4127f76cb9bdc702eb66.tar.gz | |
Introduced optimizer_switch for cost based order by limit optimization
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/main/mysqld--help.result | 5 | ||||
| -rw-r--r-- | mysql-test/main/opt_trace.result | 2 |
2 files changed, 3 insertions, 4 deletions
diff --git a/mysql-test/main/mysqld--help.result b/mysql-test/main/mysqld--help.result index ca5f8fd0b4c..60f1ae690aa 100644 --- a/mysql-test/main/mysqld--help.result +++ b/mysql-test/main/mysqld--help.result @@ -717,7 +717,8 @@ 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, not_null_range_scan + condition_pushdown_from_having, not_null_range_scan, + cost_based_order_by_limit --optimizer-trace=name Controls tracing of the Optimizer: optimizer_trace=option=val[,option=val...], where option @@ -1402,7 +1403,6 @@ The following specify which files/extra groups are read (specified before remain Prohibit update of a VIEW, which does not contain a key of the underlying table and the query uses a LIMIT clause (usually get from GUI tools) - --use-sort-nest Enable the sort nest --use-stat-tables=name Specifies how to use system statistics tables. One of: NEVER, COMPLEMENTARY, PREFERABLY, @@ -1782,7 +1782,6 @@ transaction-isolation REPEATABLE-READ transaction-prealloc-size 4096 transaction-read-only FALSE updatable-views-with-limit YES -use-sort-nest FALSE use-stat-tables PREFERABLY_FOR_QUERIES userstat FALSE verbose TRUE diff --git a/mysql-test/main/opt_trace.result b/mysql-test/main/opt_trace.result index 72cee2a428f..fa3db95eacb 100644 --- a/mysql-test/main/opt_trace.result +++ b/mysql-test/main/opt_trace.result @@ -2175,8 +2175,8 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "index": "a_c", "can_resolve_order": true, "updated_limit": 47, + "index_scan_time": 47, "range_scan_time": 4.324, - "index_scan_time": 4.324, "records": 180, "chosen": true }, |