标题: 关于强制索引，FORCE INDEX [打印本页] 作者: zhgc 时间: 2021-4-14 11:15 标题: 关于强制索引，FORCE INDEX 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 时间: 2022-4-23 14:56
多表查询时的
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