diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2019-10-07 23:07:16 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2019-10-08 16:21:03 +0530 |
| commit | ce6adae0da7abd0c2f93678a186b688bc1924e27 (patch) | |
| tree | 540058a9ad4cd3b51098eca13481bd74784c7f11 | |
| parent | a5ffaa05ae7d6e55c3fbcbc976e7c455a85f7e51 (diff) | |
| download | mariadb-git-ce6adae0da7abd0c2f93678a186b688bc1924e27.tar.gz | |
Introduced optimizer_switch for cost based order by limit optimization
| -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 a9963b17b14..c042b5073d1 100644 --- a/mysql-test/main/mysqld--help.result +++ b/mysql-test/main/mysqld--help.result @@ -716,7 +716,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 @@ -1401,7 +1402,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, @@ -1781,7 +1781,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 }, |