diff options
Diffstat (limited to 'mysql-test/main/opt_trace_index_merge.result')
| -rw-r--r-- | mysql-test/main/opt_trace_index_merge.result | 110 |
1 files changed, 55 insertions, 55 deletions
diff --git a/mysql-test/main/opt_trace_index_merge.result b/mysql-test/main/opt_trace_index_merge.result index ed5ddfd69f4..052ec2fd108 100644 --- a/mysql-test/main/opt_trace_index_merge.result +++ b/mysql-test/main/opt_trace_index_merge.result @@ -73,7 +73,7 @@ explain select * from t1 where a=1 or b=1 { "range_analysis": { "table_scan": { "rows": 1000, - "cost": 231.69 + "cost": 231.59 }, "potential_range_indexes": [ { @@ -93,10 +93,6 @@ explain select * from t1 where a=1 or b=1 { } ], "setup_range_conditions": [], - "group_index_range": { - "chosen": false, - "cause": "no group by or distinct" - }, "analyzing_range_alternatives": { "range_scan_alternatives": [], "analyzing_roworder_intersect": { @@ -115,12 +111,12 @@ explain select * from t1 where a=1 or b=1 { "using_mrr": false, "index_only": true, "rows": 1, - "cost": 1.1773, + "cost": 0.3456, "chosen": true } ], "index_to_merge": "a", - "cumulated_cost": 1.1773 + "cumulated_cost": 0.3456 }, { "range_scan_alternatives": [ @@ -131,15 +127,15 @@ explain select * from t1 where a=1 or b=1 { "using_mrr": false, "index_only": true, "rows": 1, - "cost": 1.1773, + "cost": 0.3456, "chosen": true } ], "index_to_merge": "b", - "cumulated_cost": 2.3547 + "cumulated_cost": 0.6912 } ], - "cost_of_reading_ranges": 2.3547, + "cost_of_reading_ranges": 0.6912, "use_roworder_union": true, "cause": "always cheaper than non roworder retrieval", "analyzing_roworder_scans": [ @@ -162,12 +158,16 @@ explain select * from t1 where a=1 or b=1 { } } ], - "index_roworder_union_cost": 4.1484, + "index_roworder_union_cost": 2.4849, "members": 2, "chosen": true } ] }, + "group_index_range": { + "chosen": false, + "cause": "no group by or distinct" + }, "chosen_range_access_summary": { "range_access_plan": { "type": "index_roworder_union", @@ -187,7 +187,7 @@ explain select * from t1 where a=1 or b=1 { ] }, "rows_for_plan": 2, - "cost_for_plan": 4.1484, + "cost_for_plan": 2.4849, "chosen": true } } @@ -209,19 +209,19 @@ explain select * from t1 where a=1 or b=1 { { "access_type": "index_merge", "resulting_rows": 2, - "cost": 4.1484, + "cost": 2.4849, "chosen": true } ], "chosen_access_method": { "type": "index_merge", "records": 2, - "cost": 4.1484, + "cost": 2.4849, "uses_join_buffering": false } }, "rows_for_plan": 2, - "cost_for_plan": 4.5484, + "cost_for_plan": 2.8849, "estimated_join_cardinality": 2 } ] @@ -322,7 +322,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 2243, - "cost": 2844.1, + "cost": 2700.1, "chosen": true }, @@ -336,7 +336,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 2243, - "cost": 2844.1, + "cost": 2700.1, "chosen": false, "cause": "cost" }, @@ -351,7 +351,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 2243, - "cost": 2844.1, + "cost": 2700.1, "chosen": false, "cause": "cost" } @@ -363,10 +363,10 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key1", - "index_scan_cost": 58.252, - "cumulated_index_scan_cost": 58.252, + "index_scan_cost": 10.314, + "cumulated_index_scan_cost": 10.314, "disk_sweep_cost": 1923.1, - "cumulative_total_cost": 1981.4, + "cumulative_total_cost": 1933.5, "usable": true, "matching_rows_now": 2243, "intersect_covering_with_this_index": false, @@ -375,10 +375,10 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key2", - "index_scan_cost": 58.252, - "cumulated_index_scan_cost": 116.5, + "index_scan_cost": 10.314, + "cumulated_index_scan_cost": 20.628, "disk_sweep_cost": 84.518, - "cumulative_total_cost": 201.02, + "cumulative_total_cost": 105.15, "usable": true, "matching_rows_now": 77.636, "intersect_covering_with_this_index": false, @@ -387,10 +387,10 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key3", - "index_scan_cost": 58.252, - "cumulated_index_scan_cost": 174.76, + "index_scan_cost": 10.314, + "cumulated_index_scan_cost": 30.942, "disk_sweep_cost": 0, - "cumulative_total_cost": 174.76, + "cumulative_total_cost": 30.942, "usable": true, "matching_rows_now": 2.6872, "intersect_covering_with_this_index": true, @@ -403,7 +403,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "cause": "no clustered pk index" }, "rows": 2, - "cost": 174.76, + "cost": 30.942, "covering": true, "chosen": true }, @@ -421,7 +421,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) { "type": "index_roworder_intersect", "rows": 2, - "cost": 174.76, + "cost": 30.942, "covering": true, "clustered_pk_scan": false, "intersect_of": @@ -459,7 +459,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) ] }, "rows_for_plan": 2, - "cost_for_plan": 174.76, + "cost_for_plan": 30.942, "chosen": true } ] @@ -500,7 +500,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 2243, - "cost": 152.53, + "cost": 457.06, "chosen": true }, @@ -514,13 +514,13 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 2243, - "cost": 152.53, + "cost": 457.06, "chosen": false, "cause": "cost" } ], "index_to_merge": "key1", - "cumulated_cost": 152.53 + "cumulated_cost": 457.06 }, { @@ -537,7 +537,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 2243, - "cost": 152.53, + "cost": 457.06, "chosen": true }, @@ -551,16 +551,16 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 2243, - "cost": 152.53, + "cost": 457.06, "chosen": false, "cause": "cost" } ], "index_to_merge": "key3", - "cumulated_cost": 305.05 + "cumulated_cost": 914.12 } ], - "cost_of_reading_ranges": 305.05, + "cost_of_reading_ranges": 914.12, "use_roworder_union": true, "cause": "always cheaper than non roworder retrieval", "analyzing_roworder_scans": @@ -581,10 +581,10 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key1", - "index_scan_cost": 58.252, - "cumulated_index_scan_cost": 58.252, + "index_scan_cost": 10.314, + "cumulated_index_scan_cost": 10.314, "disk_sweep_cost": 1923.1, - "cumulative_total_cost": 1981.4, + "cumulative_total_cost": 1933.5, "usable": true, "matching_rows_now": 2243, "intersect_covering_with_this_index": false, @@ -593,10 +593,10 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key2", - "index_scan_cost": 58.252, - "cumulated_index_scan_cost": 116.5, + "index_scan_cost": 10.314, + "cumulated_index_scan_cost": 20.628, "disk_sweep_cost": 84.518, - "cumulative_total_cost": 201.02, + "cumulative_total_cost": 105.15, "usable": true, "matching_rows_now": 77.636, "intersect_covering_with_this_index": false, @@ -609,7 +609,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "cause": "no clustered pk index" }, "rows": 77, - "cost": 201.02, + "cost": 105.15, "covering": false, "chosen": true } @@ -630,10 +630,10 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key3", - "index_scan_cost": 58.252, - "cumulated_index_scan_cost": 58.252, + "index_scan_cost": 10.314, + "cumulated_index_scan_cost": 10.314, "disk_sweep_cost": 1923.1, - "cumulative_total_cost": 1981.4, + "cumulative_total_cost": 1933.5, "usable": true, "matching_rows_now": 2243, "intersect_covering_with_this_index": false, @@ -642,10 +642,10 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) { "index": "key4", - "index_scan_cost": 58.252, - "cumulated_index_scan_cost": 116.5, + "index_scan_cost": 10.314, + "cumulated_index_scan_cost": 20.628, "disk_sweep_cost": 84.518, - "cumulative_total_cost": 201.02, + "cumulative_total_cost": 105.15, "usable": true, "matching_rows_now": 77.636, "intersect_covering_with_this_index": false, @@ -658,13 +658,13 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "cause": "no clustered pk index" }, "rows": 77, - "cost": 201.02, + "cost": 105.15, "covering": false, "chosen": true } } ], - "index_roworder_union_cost": 386.73, + "index_roworder_union_cost": 194.98, "members": 2, "chosen": true } @@ -685,7 +685,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) { "type": "index_roworder_intersect", "rows": 77, - "cost": 201.02, + "cost": 105.15, "covering": false, "clustered_pk_scan": false, "intersect_of": @@ -716,7 +716,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) { "type": "index_roworder_intersect", "rows": 77, - "cost": 201.02, + "cost": 105.15, "covering": false, "clustered_pk_scan": false, "intersect_of": @@ -746,7 +746,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) ] }, "rows_for_plan": 154, - "cost_for_plan": 386.73, + "cost_for_plan": 194.98, "chosen": true } ] |