작성 포맷 :
TEXT 모드, 자동 줄바꿈 사용
DELETE FROM orderCompareAddress
WHERE sidx IN (SELECT SI.idx
FROM egsfood.selling_Info AS SI INNER JOIN
egsfood.sellingOrderCode AS SO ON SI.idx = SO.sidx INNER JOIN
egsfood.selling_Data AS SD ON SO.idx = SD.soidx INNER JOIN
egsfood.orderCompareAddress AS CA ON SI.idx = CA.sidx
GROUP BY SI.idx, SD.sState
HAVING (SD.sState NOT IN (0, 1)))
WHERE sidx IN (이하 쿼리만 따로 돌리면 1초도 않걸리는데 전체를 돌리면 왜 time out 이 발생할까요?
|