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
解决方案 »
- 以下SQL插入语句哪里出错?请高手解答
- 在PL/SQL Developer中为啥看不到自己建的表呢?
- 请教一个统计语句或者解决办法
- 请教ORACLE TRIGGER问题
- 测试存储过程报错,哪位高手看一下,是什么原因?
- oracle里能用正则表达式和转义符吗
- 请教字符数据中文数字混合时排序问题;
- 请问我想了解SQLDevelper的用法,上网都没有专门介绍的,该去哪找啊?
- 高手请进:可不可以在程序中定义一个函数再传到Oracle服务器,并返回值取得结果?
- 最后结果是这样吗?hewei2003() 兄请进
- 请教10g中关于行移动的问题
- 今天取DMP文件时遇到一个不会解决的问题,大家帮我看看什么会事。
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'))