Oracle多一个条件慢了5分钟
SELECT TO_CHAR(PO.CREATE_DATE,'YYYY-MM-DD') AS ORD_DATE,PO.SALES_ORDER_ID AS ORDER#,PO.DOMS_STATUS AS ST,POL.BASE_TYPE AS PLATFM,LS.QTY*PA.QTY*POL.QTY AS QTY FROM OFSPP.PROD_ORDER_LINE POL,OFSPP.LINE_SKU LS,OFSPP.PART PA,OFSPP.PROD_ORDER PO
WHERE POL.PROD_ORDER_NUM = LS.PROD_ORDER_NUM
AND POL.LINE_NUM = LS.LINE_NUM
AND LS.LINE_SKU_SEQ = PA.LINE_SKU_SEQ
AND PO.PROD_ORDER_NUM = POL.PROD_ORDER_NUM
AND PO.FACILITY BETWEEN 'CCC2' AND 'CCC4'
AND PA.PART_NUM = 'TWPN2'
上面的这些条件用了17秒可以完成查询,但是多加了一个下面的条件竟然要5分多钟才能出结果,
AND PO.DOMS_STATUS IN ('IP,'PP')
谁能帮我看看需要啥改进的...