mysqlexplain:innerjoinanalysis;<eq_ref)betterthan&amp_MySQL:MySQLexplain bitsCN.com explainselect t.order_sn, t.cust_code, ti.tms_order_other_info_id, sp.province_name, sc.city_name, sr.region_name, st.town_name, t.buyer_addressfrom tms_order t inner join tms_order_other_info ti on t.tms_order_id=t