SELECT DISTINCT CCN,MAS_LOC,WO_NUM,WO_LINE
FROM (SELECT CCN,MAS_LOC,WO_NUM,WO_LINE FROM GLOVIA_PROD.WO WHERE CCN='CHCIZN' AND MAS_LOC='ZN' AND FIN_CLOSE_DATE IS NULL
UNION SELECT DISTINCT CCN,MAS_LOC,WO_NUM,WO_LINE FROM GLOVIA_PROD.WO_ISSUE WHERE CCN='CHCIZN' AND MAS_LOC='ZN' AND TRAN_DATE>=TO_DATE('2010-07-22','YYYY-MM-DD')
UNION SELECT DISTINCT CCN,MAS_LOC,WO_NUM,WO_LINE FROM GLOVIA_PROD.WO_COMP WHERE CCN='CHCIZN' AND MAS_LOC='ZN' AND TRAN_DATE>=TO_DATE('2010-07-22','YYYY-MM-DD')
UNION SELECT DISTINCT CCN,MAS_LOC,WO_NUM,WO_LINE FROM GLOVIA_PROD.C_WORTG WHERE CCN='CHCIZN' AND MAS_LOC='ZN' AND ENTRY_DATE>=TO_DATE('2010-07-22','YYYY-MM-DD')
)
有没有其他的写法比上面的语句查询速度更快?WO 主键是CCN、MAS_LOC、WO_NUM、WO_LINE
FROM (SELECT CCN,MAS_LOC,WO_NUM,WO_LINE FROM GLOVIA_PROD.WO WHERE CCN='CHCIZN' AND MAS_LOC='ZN' AND FIN_CLOSE_DATE IS NULL
UNION SELECT DISTINCT CCN,MAS_LOC,WO_NUM,WO_LINE FROM GLOVIA_PROD.WO_ISSUE WHERE CCN='CHCIZN' AND MAS_LOC='ZN' AND TRAN_DATE>=TO_DATE('2010-07-22','YYYY-MM-DD')
UNION SELECT DISTINCT CCN,MAS_LOC,WO_NUM,WO_LINE FROM GLOVIA_PROD.WO_COMP WHERE CCN='CHCIZN' AND MAS_LOC='ZN' AND TRAN_DATE>=TO_DATE('2010-07-22','YYYY-MM-DD')
UNION SELECT DISTINCT CCN,MAS_LOC,WO_NUM,WO_LINE FROM GLOVIA_PROD.C_WORTG WHERE CCN='CHCIZN' AND MAS_LOC='ZN' AND ENTRY_DATE>=TO_DATE('2010-07-22','YYYY-MM-DD')
)
有没有其他的写法比上面的语句查询速度更快?WO 主键是CCN、MAS_LOC、WO_NUM、WO_LINE
SELECT CCN, MAS_LOC, WO_NUM, WO_LINE
FROM (SELECT CCN, MAS_LOC, WO_NUM, WO_LINE
FROM GLOVIA_PROD.WO
WHERE CCN = 'CHCIZN' AND
MAS_LOC = 'ZN' AND
FIN_CLOSE_DATE IS NULL
UNION
SELECT CCN, MAS_LOC, WO_NUM, WO_LINE
FROM GLOVIA_PROD.WO_ISSUE
WHERE CCN = 'CHCIZN' AND
MAS_LOC = 'ZN' AND
TRAN_DATE >= TO_DATE('2010-07-22', 'YYYY-MM-DD')
UNION
SELECT CCN, MAS_LOC, WO_NUM, WO_LINE
FROM GLOVIA_PROD.WO_COMP
WHERE CCN = 'CHCIZN' AND
MAS_LOC = 'ZN' AND
TRAN_DATE >= TO_DATE('2010-07-22', 'YYYY-MM-DD')
UNION
SELECT CCN, MAS_LOC, WO_NUM, WO_LINE
FROM GLOVIA_PROD.C_WORTG
WHERE CCN = 'CHCIZN' AND
MAS_LOC = 'ZN' AND
ENTRY_DATE >= TO_DATE('2010-07-22', 'YYYY-MM-DD'))