SELECT /*+ PARALLEL(a, 4) */ MAX(DCTIME)
FROM PM_RAW_B_CDMANO7LINK a
WHERE a.DCTIME > 1285199103000
AND a.DCTIME < 1312847103000
AND a.KPI_NO IN
(0, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177)
and substr(kbp, 1, 2) = 91
从原来的200s提高到50s
阅读(572) | 评论(0) | 转发(0) |
