关于强制索引，FORCE INDEX

zhgc

update smt.r_kpi_smt_t force index (KPI_WORK_TIME)
                                set flag=3,finish_time=now()
                                where error_code='004' and station=l_machine
                                and flag=0 and slot=l_slot and work_time>date_add(now(),interval -2 hour);


update smt.r_kpi_smt_t force index (KPI_WORK_TIME)
                                                set flag=3,finish_time=now()
                                    where error_code='003' and station=l_machine
                                    and flag=0 and work_time>date_add(now(),interval -2 hour);


SELECT wip_group INTO l_group FROM r_wip_tracking_t FORCE INDEX(IMEI,PALLET_NO)
  WHERE (imei= l_pallet OR pallet_no=l_pallet) AND wip_group <>MYGROUP LIMIT 1;


  SELECT pallet_full_flag INTO l_group FROM r_wip_tracking_t FORCE INDEX(IMEI,PALLET_NO)
  WHERE (imei= l_pallet OR pallet_no=l_pallet) AND pallet_full_flag='N'  LIMIT 1;


SELECT wip_group INTO l_group FROM r_wip_tracking_t FORCE INDEX(IMEI,PALLET_NO)
  WHERE (imei= l_pallet OR pallet_no=l_pallet) AND wip_group not in
('FG','REPALLET','SHIPPING') LIMIT 1;

zhgc

多表查询时的

SELECT A.MODEL_NAME 机型,b.MAC, a.SHIPPING_SN ASN, A.CARTON_NO 箱号,a.IMEI 栈板号,a.SHIP_NO 出货单号,A.OUT_LINE_TIME 发货日期
  FROM SFC.`r_wip_tracking_t` A force index (SHIP_NO) ,SFC.`mes_data_key_t` B WHERE
A.SERIAL_NUMBER=B.SN AND A.SHIP_NO='2204220011'
ORDER BY A.CARTON_NO
LIMIT 0,40