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:

  1. Add an index on the back_money_info table for the STATUS column.
  2. Add an index on the back_money_info table for the contract_code column.
  3. Add an index on the back_money_info table for the business column.
  4. Add an index on the contract_info table for the contract_code column.
  5. Add an index on the back_money_bank table for the rec_id column.
  6. Add an index on the erp_dict_info table for the CODE column.
  7. Add an index on the erp_cust_company table for the company_code column and the back_use_flag column.
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

原文地址: https://www.cveoy.top/t/topic/bE6E 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录