以下sql在 toi.BUY_PROJECT = '20'此条件会堵塞数据库,而值变成其它值就没有问题,如果把toi.BUY_TIME时间限制注释掉也不会堵塞数据库,知识面有些窄,不明白
select count(0)
from (SELECT toi.ID,
toi.MOBILE,
toi.BUY_TIME,
toi.BUY_PROJECT,
toi.SIGN_TIME,
toi.AMOUNT,
toi.SELLER_ID,
toi.SELLER_CODE,
toi.INVITATION_CODE,
toi.ORDER_ID,
toi.TYPE,
tcji.IS_MOVE,
tcji.IS_CURR,
tcji.MOVE_DATE,
tcji.MOVE_TYPE,
tcji.MOVE_REMARK,
toi.CHANNEL,
toi.USER_NAME,
toi.USER_ID,
toi.CREATE_DATE,
toi.OWNER,
tsui.USER_FULL_NAME BUSSNESS_NAME,
tcjei.REGISTER_TIME
FROM T_ORD_INFO toi,
T_CUSTO_J_INF tcji,
T_CUSTO_J_EXE_INF tcjei,
T_SYS_USER_INF tsui
WHERE toi.USER_ID = tcjei.USER_ID
AND tcji.ID = tcjei.CUSTO_ID
AND tcji.OWNER = tsui.USER_ID
AND tcji.IS_CURR = '1'
and toi.BUY_TIME >= to_date('2017-06-01 00:00:00', 'yyyy-MM-dd HH24:mi:ss')
and toi.BUY_TIME <= to_date('2017-06-10 23:59:59', 'yyyy-MM-dd HH24:mi:ss')
AND toi.BUY_PROJECT = '20'
ORDER BY toi.BUY_TIME DESC) tmp_count
;