diff options
Diffstat (limited to 'mysql-test/main/opt_trace.result')
| -rw-r--r-- | mysql-test/main/opt_trace.result | 44 |
1 files changed, 22 insertions, 22 deletions
diff --git a/mysql-test/main/opt_trace.result b/mysql-test/main/opt_trace.result index 93020416551..f3bc5e40ea9 100644 --- a/mysql-test/main/opt_trace.result +++ b/mysql-test/main/opt_trace.result @@ -3248,7 +3248,7 @@ explain extended select * from t1 where a in (select pk from t10) { { "strategy": "SJ-Materialization", "records": 3, - "cost": 6.914282227 + "cost": 8.664282227 }, { "strategy": "DuplicateWeedout", @@ -3314,7 +3314,7 @@ explain extended select * from t1 where a in (select pk from t10) { "best_join_order": ["t1", "<subquery2>"], "best_access_method": { "rows": 3, - "cost": 6.914282227 + "cost": 8.664282227 } }, { @@ -5038,7 +5038,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ { "strategy": "SJ-Materialization", "records": 3, - "cost": 9.10769043 + "cost": 10.75769043 }, { "strategy": "DuplicateWeedout", @@ -5171,7 +5171,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "best_join_order": ["t1", "<subquery2>"], "best_access_method": { "rows": 3, - "cost": 9.10769043 + "cost": 10.75769043 } }, { @@ -7565,7 +7565,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { { "strategy": "SJ-Materialization", "records": 3, - "cost": 16.01281738 + "cost": 19.46281738 }, { "strategy": "DuplicateWeedout", @@ -7607,7 +7607,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { } }, "rows_for_plan": 27, - "cost_for_plan": 28.72050781, + "cost_for_plan": 32.17050781, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -7642,7 +7642,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { } }, "rows_for_plan": 81, - "cost_for_plan": 62.87307129, + "cost_for_plan": 66.32307129, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -7678,25 +7678,25 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { } }, "rows_for_plan": 729, - "cost_for_plan": 394.1807617, + "cost_for_plan": 397.6307617, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "records": 27, - "cost": 339.9126465 + "cost": 343.3626465 }, { "strategy": "SJ-Materialization", "records": 27, - "cost": 44.18076172 + "cost": 57.08076172 }, { "strategy": "DuplicateWeedout", "records": 27, - "dups_cost": 394.1807617, + "dups_cost": 397.6307617, "write_cost": 5.05, "full_lookup_cost": 109.35, - "total_cost": 508.5807617 + "total_cost": 512.0307617 }, { "chosen_strategy": "SJ-Materialization" @@ -7737,7 +7737,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { } }, "rows_for_plan": 243, - "cost_for_plan": 129.1781982, + "cost_for_plan": 132.6281982, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -7770,7 +7770,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { } }, "rows_for_plan": 9, - "cost_for_plan": 20.91538086, + "cost_for_plan": 24.36538086, "semijoin_strategy_choice": [], "rest_of_plan": [ { @@ -7805,7 +7805,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { } }, "rows_for_plan": 81, - "cost_for_plan": 56.57307129, + "cost_for_plan": 60.02307129, "semijoin_strategy_choice": [], "pruned_by_cost": true }, @@ -7841,7 +7841,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { } }, "rows_for_plan": 81, - "cost_for_plan": 56.57307129, + "cost_for_plan": 60.02307129, "semijoin_strategy_choice": [], "pruned_by_cost": true } @@ -7874,7 +7874,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { } }, "rows_for_plan": 27, - "cost_for_plan": 28.72050781, + "cost_for_plan": 32.17050781, "semijoin_strategy_choice": [], "pruned_by_heuristic": true } @@ -8387,7 +8387,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { ], "best_access_method": { "rows": 27, - "cost": 44.18076172 + "cost": 57.08076172 } }, { @@ -10212,8 +10212,8 @@ json_detailed(json_extract(trace, '$**.choose_best_splitting')) "table": "t2", "key": "idx_a", "record_count": 4, - "cost": 3.651150919, - "unsplit_cost": 46.6794762 + "cost": 4.157170953, + "unsplit_cost": 60.1794762 } } ] @@ -10226,8 +10226,8 @@ json_detailed(json_extract(trace, '$**.lateral_derived')) [ { - "startup_cost": 14.60460368, - "splitting_cost": 3.651150919, + "startup_cost": 16.62868381, + "splitting_cost": 4.157170953, "records": 1 } ] |