这条SQL再有优化余地吗

select /*+index(mbf IDX_MT_BIZ_FIN_FIN_DATE_01;mprf IDX_MT_PAY_RECORD_FIN_1) */ decode(pers_type,'1','学生','5','老师','教授') pers_type,       nvl(count(distinct(mbf.indi_id)), 0.00) as jzrs,       nvl(sum(decode(mprf.fund_id,                      '003',                      mprf.real_pay,                      '901',                      mprf.real_pay,                      '001',                      mprf.real_pay,                      '301',                      mprf.real_pay,                      '201',                      mprf.real_pay,                      '999',                      mprf.real_pay,                      0)),           0) as all_money,       nvl(sum(decode(mprf.fund_id, '003', mprf.real_pay)), 0.00) as grzh_money,       nvl(sum(decode(mprf.fund_id, '001', mprf.real_pay)), 0.00) as tc_money,       nvl(sum(decode(mprf.fund_id, '301', mprf.real_pay)), 0.00) as offical_money,       nvl(sum(decode(mprf.fund_id, '201', mprf.real_pay)), 0.00) as db_money,       nvl(sum(decode(mprf.fund_id, '901', mprf.real_pay)), 0.00) as grzf_yw,       nvl(sum(decode(mprf.fund_id, '999', mprf.real_pay)), 0.00) as grzf_money  from TABLEA mprf, TABLEB mbf  where  mbf.serial_no = mprf.serial_no   and mprf.valid_flag = '1'   and mbf.valid_flag = '1'   and mbf.center_id = '430201'   and mbf.biz_type between 10 and 14   -- and mbf.biz_type in (10, 11, 12, 13, 14)   and to_char(mbf.fin_date, 'yyyymmdd') >= '20000101'   and to_char(mbf.fin_date, 'yyyymmdd') <=  '20100808'   and mbf.pers_type in ('1','2','9','5')   group by decode(pers_type,'1','学生','5','老师','教授')