使用并行提高速度

jl8323

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