Created
May 31, 2018 09:44
-
-
Save aping/c4388d49d666c43172a856d77001f4ce to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"steps": [ | |
{ | |
"join_preparation": { | |
"select#": 1, | |
"steps": [ | |
{ | |
"expanded_query": "/* select#1 */ select `datayesdb`.`idx_weight`.`SECURITY_ID` AS `SECURITY_ID`,min(`datayesdb`.`idx_weight`.`EFF_DATE`) AS `startDate`,max(`datayesdb`.`idx_weight`.`EFF_DATE`) AS `endDate` from `datayesdb`.`idx_weight` where (`datayesdb`.`idx_weight`.`SECURITY_ID` = 1782)" | |
} | |
] | |
} | |
}, | |
{ | |
"join_optimization": { | |
"select#": 1, | |
"steps": [ | |
{ | |
"condition_processing": { | |
"condition": "WHERE", | |
"original_condition": "(`datayesdb`.`idx_weight`.`SECURITY_ID` = 1782)", | |
"steps": [ | |
{ | |
"transformation": "equality_propagation", | |
"resulting_condition": "multiple equal(1782, `datayesdb`.`idx_weight`.`SECURITY_ID`)" | |
}, | |
{ | |
"transformation": "constant_propagation", | |
"resulting_condition": "multiple equal(1782, `datayesdb`.`idx_weight`.`SECURITY_ID`)" | |
}, | |
{ | |
"transformation": "trivial_condition_removal", | |
"resulting_condition": "multiple equal(1782, `datayesdb`.`idx_weight`.`SECURITY_ID`)" | |
} | |
] | |
} | |
}, | |
{ | |
"table_dependencies": [ | |
{ | |
"table": "`datayesdb`.`idx_weight`", | |
"row_may_be_null": false, | |
"map_bit": 0, | |
"depends_on_map_bits": [ | |
] | |
} | |
] | |
}, | |
{ | |
"ref_optimizer_key_uses": [ | |
{ | |
"table": "`datayesdb`.`idx_weight`", | |
"field": "SECURITY_ID", | |
"equals": "1782", | |
"null_rejecting": false | |
}, | |
{ | |
"table": "`datayesdb`.`idx_weight`", | |
"field": "SECURITY_ID", | |
"equals": "1782", | |
"null_rejecting": false | |
} | |
] | |
}, | |
{ | |
"rows_estimation": [ | |
{ | |
"table": "`datayesdb`.`idx_weight`", | |
"range_analysis": { | |
"table_scan": { | |
"rows": 68945218, | |
"cost": 1.42e7 | |
}, | |
"potential_range_indices": [ | |
{ | |
"index": "PRIMARY", | |
"usable": false, | |
"cause": "not_applicable" | |
}, | |
{ | |
"index": "BPK_AK", | |
"usable": true, | |
"key_parts": [ | |
"SECURITY_ID", | |
"CONS_ID", | |
"EFF_DATE" | |
] | |
}, | |
{ | |
"index": "tmst", | |
"usable": false, | |
"cause": "not_applicable" | |
}, | |
{ | |
"index": "idx_weight_ix", | |
"usable": true, | |
"key_parts": [ | |
"SECURITY_ID", | |
"EFF_DATE", | |
"ID" | |
] | |
} | |
], | |
"best_covering_index_scan": { | |
"index": "idx_weight_ix", | |
"cost": 1.39e7, | |
"chosen": true | |
}, | |
"setup_range_conditions": [ | |
], | |
"group_index_range": { | |
"chosen": false, | |
"cause": "not_group_by_or_distinct" | |
}, | |
"analyzing_range_alternatives": { | |
"range_scan_alternatives": [ | |
{ | |
"index": "BPK_AK", | |
"ranges": [ | |
"1782 <= SECURITY_ID <= 1782" | |
], | |
"index_dives_for_eq_ranges": true, | |
"rowid_ordered": false, | |
"using_mrr": false, | |
"index_only": true, | |
"rows": 1031808, | |
"cost": 209757, | |
"chosen": true | |
}, | |
{ | |
"index": "idx_weight_ix", | |
"ranges": [ | |
"1782 <= SECURITY_ID <= 1782" | |
], | |
"index_dives_for_eq_ranges": true, | |
"rowid_ordered": false, | |
"using_mrr": false, | |
"index_only": true, | |
"rows": 887856, | |
"cost": 179627, | |
"chosen": true | |
} | |
], | |
"analyzing_roworder_intersect": { | |
"usable": false, | |
"cause": "too_few_roworder_scans" | |
} | |
}, | |
"chosen_range_access_summary": { | |
"range_access_plan": { | |
"type": "range_scan", | |
"index": "idx_weight_ix", | |
"rows": 887856, | |
"ranges": [ | |
"1782 <= SECURITY_ID <= 1782" | |
] | |
}, | |
"rows_for_plan": 887856, | |
"cost_for_plan": 179627, | |
"chosen": true | |
} | |
} | |
} | |
] | |
}, | |
{ | |
"considered_execution_plans": [ | |
{ | |
"plan_prefix": [ | |
], | |
"table": "`datayesdb`.`idx_weight`", | |
"best_access_path": { | |
"considered_access_paths": [ | |
{ | |
"access_type": "ref", | |
"index": "BPK_AK", | |
"rows": 1.03e6, | |
"cost": 209757, | |
"chosen": true | |
}, | |
{ | |
"access_type": "ref", | |
"index": "idx_weight_ix", | |
"rows": 887856, | |
"cost": 179627, | |
"chosen": true | |
}, | |
{ | |
"access_type": "range", | |
"cause": "heuristic_index_cheaper", | |
"chosen": false | |
} | |
] | |
}, | |
"cost_for_plan": 179627, | |
"rows_for_plan": 887856, | |
"chosen": true | |
} | |
] | |
}, | |
{ | |
"attaching_conditions_to_tables": { | |
"original_condition": "(`datayesdb`.`idx_weight`.`SECURITY_ID` = 1782)", | |
"attached_conditions_computation": [ | |
], | |
"attached_conditions_summary": [ | |
{ | |
"table": "`datayesdb`.`idx_weight`", | |
"attached": null | |
} | |
] | |
} | |
}, | |
{ | |
"refine_plan": [ | |
{ | |
"table": "`datayesdb`.`idx_weight`" | |
} | |
] | |
} | |
] | |
} | |
}, | |
{ | |
"join_execution": { | |
"select#": 1, | |
"steps": [ | |
] | |
} | |
} | |
] | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment