diff options
| author | unknown <serg@serg.mysql.com> | 2002-11-17 18:58:03 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2002-11-17 18:58:03 +0100 |
| commit | 4589844513f1663d49f32ed6cdf1e14003f940bc (patch) | |
| tree | 771a80d6c9d19b9007b8ba8a7f4e3a20fdddf247 /sql/sql_select.cc | |
| parent | 564c7b241fface9cc9843f47972f3a4060d2bd4d (diff) | |
| download | mariadb-git-4589844513f1663d49f32ed6cdf1e14003f940bc.tar.gz | |
merge::records_in_range and optimizer
sql/sql_select.cc:
optimizer bug fixed. (what's the difference between s->records ans s->found_records ?)
Diffstat (limited to 'sql/sql_select.cc')
| -rw-r--r-- | sql/sql_select.cc | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/sql_select.cc b/sql/sql_select.cc index 4f3ebd61774..a7e378420f2 100644 --- a/sql/sql_select.cc +++ b/sql/sql_select.cc @@ -1219,7 +1219,7 @@ make_join_statistics(JOIN *join,TABLE_LIST *tables,COND *conds, select->quick=0; if (records != HA_POS_ERROR) { - s->found_records=records; + s->records=s->found_records=records; s->read_time= (ha_rows) (s->quick ? s->quick->read_time : 0.0); } } @@ -1944,7 +1944,7 @@ find_best(JOIN *join,table_map rest_tables,uint idx,double record_count, records This gives the formula: records= (x * (b-a) + a*c-b)/(c-1) - + b = records matched by whole key a = records matched by first key part (10% of all records?) c = number of key parts in key |