mysql 临时结果集_MySQL--派生表临时结果集中的AutoKey

{

"query_block": {

"select_id":1,

"cost_info": {

"query_cost": "10397.97"

},

"nested_loop":[{

"table": {

"table_name": "T2",

"access_type": "index",

"possible_keys": [

"PRIMARY"],

"key": "idx_purpose_code",

"used_key_parts":["purpose_code"],

"key_length": "387",

"rows_examined_per_scan":851,

"rows_produced_per_join":851,

"filtered": "100.00",

"using_index": true,

"cost_info": {

"read_cost": "10.00",

"eval_cost": "170.20",

"prefix_cost": "180.20",

"data_read_per_join": "15M"

},

"used_columns":["cluster_id",

"purpose_code"]}

},

{

"table": {

"table_name": "T1",

"access_type": "ref",

"possible_keys":[""],

"key": "",

"used_key_parts":["cluster_id"],

"key_length": "8",

"ref":["exps_db.T2.cluster_id"],

"rows_examined_per_scan":10,

"rows_produced_per_join":8514,

"filtered": "100.00",

"cost_info": {

"read_cost": "8514.81",

"eval_cost": "1702.96",

"prefix_cost": "10397.97",

"data_read_per_join": "199K"

},

"used_columns":["cluster_id",

"instance_count"],

"materialized_from_subquery": {

"using_temporary_table": true,

"dependent": false,

"cacheable": true,

"query_block": {

"select_id":2,

"cost_info": {

"query_cost": "372.20"

},

"grouping_operation": {

"using_filesort": false,

"table": {

"table_name": "assets_instance",

"access_type": "index",

"possible_keys":["ForeignKey_cluster_id"],

"key": "ForeignKey_cluster_id",

"used_key_parts":["cluster_id"],

"key_length": "8",

"rows_examined_per_scan":1771,

"rows_produced_per_join":1771,

"filtered": "100.00",

"using_index": true,

"cost_info": {

"read_cost": "18.00",

"eval_cost": "354.20",

"prefix_cost": "372.20",

"data_read_per_join": "5M"

},

"used_columns":["instance_id",

"cluster_id"]}

}

}

}

}

}

]

}

}