今天,还是用第一篇博文的例子,看下怎么消除谓词推进。首先先上图,这是一个发生了谓词推进的例子。 sql: SELECT COUNT(1) AS count FROM (
SELECT COUNT(1) AS count
FROM (
SELECT a.ykf272, a.akb020, a.akb021, a.yka094, a.ake005
, a.yke936, a.ykf282, a.aac003, a.aac001, a.aac002
, a.akc225, a.akc226, a.ykf275, a.ykf281, a.ykf284
, a.ykf283, a.yke453, a.aae011, a.aae036, a.yke923
, a.yke925, a.yab003, b.yka059, b.yka002, b.yke627
, b.yka095, a.yke938, a.yke940, x.ake006
, pkg_common.fun_getAaa103('YKF062', x.ykf062) AS ykf062
, (
SELECT c.aaa103
FROM bm_ykf063 c
WHERE b.ykf063 = c.ykf063
) AS ykf063, b.yka007, x.ykf064
, (
SELECT pkg_common.fun_getAaa103('AKA070', c.aka070)
FROM ka02 c
WHERE b.yka002 = c.yka002
) AS aka070, pkg_common.fun_getAaa103('YKE469', b.yke469) AS yke469, b.aka074
FROM kz37k1 a, ka05 b, (
SELECT akb020, ake005, yka094, ake006, ykf062
, ykf064
FROM (
SELECT x.akb020, x.ake005, x.yka094, x.ake006, x.ykf064
, x.ykf062, DENSE_RANK() OVER (PARTITioN BY x.akb020, x.ake005, x.yka094 ORDER BY aae030 DESC) AS r
FROM kb05k1 x
)
WHERE r = 1
) x
WHERE a.yka094 = b.yka094
AND a.akb020 = x.akb020
AND a.ake005 = x.ake005
AND a.yka094 = x.yka094
AND a.akb020 = '855855'
AND a.yab003 = '0001'
AND trunc(a.aae036, 'dd') >= '08-APR-18'
AND trunc(a.aae036, 'dd') <= '10-APR-18')a;
--结束END--
本文标题: 消除谓词推进
本文链接: https://www.lsjlt.com/news/48194.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-16
2024-05-16
2024-05-16
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0