EXPLAINSELECT bmbm_code AS bmCode bmbank AS bankId bmcontract_code AS contractCode cierp_contract_code AS erpContractCode bmpay_style AS payStyle ciearn_money AS earnMoney cibegin_time AS beginTime ci
Without knowing the size and complexity of the database, it is difficult to determine what specific indexes would be most beneficial for this query. However, some general recommendations for optimizing the query performance could be:
- Add an index on the
back_money_infotable for theSTATUScolumn. - Add an index on the
back_money_infotable for thecontract_codecolumn. - Add an index on the
back_money_infotable for thebusinesscolumn. - Add an index on the
contract_infotable for thecontract_codecolumn. - Add an index on the
back_money_banktable for therec_idcolumn. - Add an index on the
erp_dict_infotable for theCODEcolumn. - Add an index on the
erp_cust_companytable for thecompany_codecolumn and theback_use_flagcolumn.
原文地址: https://www.cveoy.top/t/topic/bE6E 著作权归作者所有。请勿转载和采集!