diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2021-02-09 11:41:30 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2021-02-09 12:21:27 +0530 |
| commit | 37a10ddf9001e4d1e80a09a51f98e7e6579bbc84 (patch) | |
| tree | ab196bc3bd1842a557d80c37f2a59e06c3812620 /sql | |
| parent | 1a18aee615c72919867c14d8fe32ed39480086e5 (diff) | |
| download | mariadb-git-37a10ddf9001e4d1e80a09a51f98e7e6579bbc84.tar.gz | |
Enabled the order by limit optimization by default
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/sql_priv.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/sql_priv.h b/sql/sql_priv.h index 79c5b87d77d..bb8b42196f5 100644 --- a/sql/sql_priv.h +++ b/sql/sql_priv.h @@ -265,7 +265,8 @@ OPTIMIZER_SWITCH_COND_PUSHDOWN_FOR_SUBQUERY | \ OPTIMIZER_SWITCH_USE_ROWID_FILTER | \ OPTIMIZER_SWITCH_COND_PUSHDOWN_FROM_HAVING | \ - OPTIMIZER_SWITCH_OPTIMIZE_JOIN_BUFFER_SIZE) + OPTIMIZER_SWITCH_OPTIMIZE_JOIN_BUFFER_SIZE | \ + OPTIMIZER_SWITCH_COST_BASED_ORDER_BY_LIMIT) /* Replication uses 8 bytes to store SQL_MODE in the binary log. The day you |