diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-10-07 18:03:42 +0300 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-10-07 18:03:42 +0300 |
| commit | 1a48dd4e2bf0c6353bbf76b1f9b768620e0aa090 (patch) | |
| tree | e8b98d4a75e63235bc86e6683cdea26c65b05c21 /sql/table.h | |
| parent | 9226c847f5ac5424b50da07623e6e75a60725bc0 (diff) | |
| download | mariadb-git-1a48dd4e2bf0c6353bbf76b1f9b768620e0aa090.tar.gz | |
Bug #43029: FORCE INDEX FOR ORDER BY is ignored when join
buffering is used
FORCE INDEX FOR ORDER BY now prevents the optimizer from
using join buffering. As a result the optimizer can use
indexed access on the first table and doesn't need to
sort the complete resultset at the end of the statement.
Diffstat (limited to 'sql/table.h')
| -rw-r--r-- | sql/table.h | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/table.h b/sql/table.h index 40372fa91cf..e4a382c799f 100644 --- a/sql/table.h +++ b/sql/table.h @@ -752,6 +752,18 @@ struct st_table { bytes, it would take up 4. */ my_bool force_index; + + /** + Flag set when the statement contains FORCE INDEX FOR ORDER BY + See TABLE_LIST::process_index_hints(). + */ + my_bool force_index_order; + + /** + Flag set when the statement contains FORCE INDEX FOR GROUP BY + See TABLE_LIST::process_index_hints(). + */ + my_bool force_index_group; my_bool distinct,const_table,no_rows; /** |