- 论坛徽章:
- 0
|
其中 base_ticket 表数据5000多万, fct_lowfreq_serv 表数据1000多万,请问这个SQL应该怎么改写,我只想知道怎么优化此SQL语句,其他系统设置和数据库参数调整就不用了。
SELECT calling_area_code,
calling_nbr,
called_area_code,
called_nbr,
trunk_in_nbr,
trunk_out_nbr,
start_date,
start_time,
end_time,
duration,h
direction,
b.serv_id,
b.serv_seq_nbr,
b.key_month,
ticket_type_cd,
rate,
t_count,
charge,
ext_rate,
ext_count,
ext_charge,
oper_id
FROM base_ticket a, fct_lowfreq_serv b
WHERE a.serv_seq_nbr = b.serv_seq_nbr
AND a.serv_id = b.serv_id
AND a.key_month = '2005-05'
AND b.key_month = '2005-06'; |
|