mescloud/db/mysql/optimize_process_param_list_indexes.sql

-- 工艺过程参数列表加速索引
-- 建议在业务低峰执行。若提示 Duplicate key name，说明该索引已存在，跳过对应语句即可。

ALTER TABLE `mes_product_arc_welding`
  ADD INDEX `idx_mpaw_create_date` (`create_date`),
  ADD INDEX `idx_mpaw_sn` (`sn`),
  ADD INDEX `idx_mpaw_line_oprno` (`line_sn`, `oprno`);

ALTER TABLE `mes_product_cmt`
  ADD INDEX `idx_mpc_create_date` (`create_date`),
  ADD INDEX `idx_mpc_sn` (`sn`),
  ADD INDEX `idx_mpc_line_oprno` (`line_sn`, `oprno`);

ALTER TABLE `mes_product_prod`
  ADD INDEX `idx_mpp_date_time` (`date_time`),
  ADD INDEX `idx_mpp_sn` (`sn`);

ALTER TABLE `mes_product_fsw`
  ADD INDEX `idx_mpf_create_date` (`create_date`),
  ADD INDEX `idx_mpf_sn` (`sn`);

ALTER TABLE `mes_product_qm`
  ADD INDEX `idx_mpq_test_time` (`test_time`),
  ADD INDEX `idx_mpq_oprno` (`oprno`);

ALTER TABLE `mes_torsional_process`
  ADD INDEX `idx_mtp_create_date` (`create_date`),
  ADD INDEX `idx_mtp_sn` (`sn`);

ALTER TABLE `mes_electric_torque`
  ADD INDEX `idx_met_create_date` (`create_date`),
  ADD INDEX `idx_met_sn` (`sn`);

ALTER TABLE `mes_product_glue_duration`
  ADD INDEX `idx_mpgd_create_date` (`create_date`),
  ADD INDEX `idx_mpgd_sn` (`sn`);

ALTER TABLE `mes_product_record`
  ADD INDEX `idx_mpr_sn_oprno_line` (`sn`, `oprno`, `line_sn`);