diff options
Diffstat (limited to 'mysql-test/main/opt_trace_index_merge_innodb.result')
| -rw-r--r-- | mysql-test/main/opt_trace_index_merge_innodb.result | 35 |
1 files changed, 18 insertions, 17 deletions
diff --git a/mysql-test/main/opt_trace_index_merge_innodb.result b/mysql-test/main/opt_trace_index_merge_innodb.result index d0a4f7cd24b..0b0f6f0d2fc 100644 --- a/mysql-test/main/opt_trace_index_merge_innodb.result +++ b/mysql-test/main/opt_trace_index_merge_innodb.result @@ -89,7 +89,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "range_analysis": { "table_scan": { "rows": 1000, - "cost": 253 + "cost": 0.1764192 }, "potential_range_indexes": [ { @@ -118,8 +118,9 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "using_mrr": false, "index_only": false, "rows": 1000, - "cost": 252.02, - "chosen": true + "cost": 0.19579056, + "chosen": false, + "cause": "cost" }, { "index": "key1", @@ -128,7 +129,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "using_mrr": false, "index_only": false, "rows": 1, - "cost": 1.270146475, + "cost": 0.00415068, "chosen": true } ], @@ -136,10 +137,10 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "intersecting_indexes": [ { "index": "key1", - "index_scan_cost": 0.525146475, - "cumulated_index_scan_cost": 0.525146475, - "disk_sweep_cost": 0.752076843, - "cumulative_total_cost": 1.277223319, + "index_scan_cost": 0.001661605, + "cumulated_index_scan_cost": 0.001661605, + "disk_sweep_cost": 0.00171364, + "cumulative_total_cost": 0.003375245, "usable": true, "matching_rows_now": 1, "intersect_covering_with_this_index": false, @@ -151,7 +152,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "cause": "cost" }, "chosen": false, - "cause": "cost" + "cause": "too few indexes to merge" }, "analyzing_index_merge_union": [] }, @@ -167,7 +168,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "ranges": ["(1) <= (key1) <= (1)"] }, "rows_for_plan": 1, - "cost_for_plan": 1.270146475, + "cost_for_plan": 0.00415068, "chosen": true } } @@ -177,7 +178,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "rowid_filters": [ { "key": "key1", - "build_cost": 0.526146475, + "build_cost": 0.000002653, "rows": 1 } ] @@ -215,7 +216,7 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "index": "key1", "used_range_estimates": true, "rows": 1, - "cost": 1.250146475, + "cost": 0.00335956, "chosen": true }, { @@ -226,9 +227,9 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { ], "chosen_access_method": { "type": "ref", - "records_read": 1, - "records_out": 1, - "cost": 1.250146475, + "rows_read": 1, + "rows_out": 1, + "cost": 0.00335956, "uses_join_buffering": false } } @@ -239,14 +240,14 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { "plan_prefix": [], "table": "t1", "rows_for_plan": 1, - "cost_for_plan": 1.250146475 + "cost_for_plan": 0.00335956 } ] }, { "best_join_order": ["t1"], "rows": 1, - "cost": 1.250146475 + "cost": 0.00335956 }, { "substitute_best_equal": { |