1)SQL 性能提升
select
c.scan_start_time,
a.zh_name,
a.cgi,
b.region_name,
round(round(decode(c.succinitalsetup,0,0,(c.attrelenb-c.attrelenbnormal)/c.succinitalsetup),4),6) Wirelessdrops,
c.attrelenb,
c.attrelenbnormal,
c.succinitalsetup,
round(round(decode(c.nbrattestab,0,0,c.nbrsuccestab/c.nbrattestab)*decode(c.attconnestab,0,0,c.succconnestab/c.attconnestab),4),6) Wirelessconnection,
c.nbrsuccestab,
c.nbrattestab,
c.succconnestab,
c.attconnestab
from tcc_eutrancell a,outer region_city b,outer tpa_eutrancell_ne c
where a.scan_start_time=extend(current,year to day)-1 units day
and c.scan_start_time in (select first_result from tcc_time_snap where first_result >=extend(current,year to day)-1 units day
and first_result <=extend(current,year to day) and time_type=0 and s_hour in (0,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23))
select
c.scan_start_time,
a.zh_name,
a.cgi,
b.region_name,
round(round(decode(c.succinitalsetup,0,0,(c.attrelenb-c.attrelenbnormal)/c.succinitalsetup),4),6) Wirelessdrops,
c.attrelenb,
c.attrelenbnormal,
c.succinitalsetup,
round(round(decode(c.nbrattestab,0,0,c.nbrsuccestab/c.nbrattestab)*decode(c.attconnestab,0,0,c.succconnestab/c.attconnestab),4),6) Wirelessconnection,
c.nbrsuccestab,
c.nbrattestab,
c.succconnestab,
c.attconnestab
from tcc_eutrancell a,outer region_city b,outer tpa_eutrancell_ne c
where a.scan_start_time=extend(current,year to day)-1 units day
and c.scan_start_time in (select first_result from tcc_time_snap where first_result >=extend(current,year to day)-1 units day
and first_result <=extend(current,year to day) and time_type=0 and s_hour in (0,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23))