SQL优化
select count(*)
FROM flight_info f
INNER JOIN spa_plan p
ON f.dest_code=p.depAirportCode
WHERE f.area_type='D'
and (to_date(p.timeseries||' '||p.Deptime,'YYYY/MM/DD HH24mi')- (case when f.arrival_time < f.takeoff_time then to_date(f.flight_date||' '||substr(f.arrival_time,1,2)||':'||substr(f.arrival_time,3,2)||':00','yyyy-MM-dd HH24:mi:ss')+1 else to_date(f.flight_date||' '||substr(f.arrival_time,1,2)||':'||substr(f.arrival_time,3,2)||':00','yyyy-MM-dd HH24:mi:ss')end ) )* 24>=3;
加上最后时间大于3天 就不走索引两个表都走全表扫描 查询18秒