利用no_merge优化

SQL> select a.unit3_code 机构编码,
  2         a.unit3_name 机构名称,
  3         a.dept1_code 部门编码,
  4         a.dept1_name 部门名称,
  5         a.mgr_code   客户经理编码,
  6         a.mgr_name   客户经理名称,
  7         b.base       基数
  8    from s_pm_mgr_dept_rela a,
  9         (select t2.mgr_code, sum(T1.avg * t2.share_rate / 100) / 10000 base
 10            from (select acct_no_pk,
 11                         (SUM(DECODE(T1.DATA_DATE, '20121217', T1.Y_ADD_AF, 0)) -
 12                         SUM(DECODE(T1.DATA_DATE, '20120101', T1.Y_ADD_AF, 0)) +
 13                         SUM(DECODE(T1.DATA_DATE,
 14                                     '20120101',
 15                                     T1.ADJUST_AMT_AF,
 16                                     0))) /
 17                         PKG_UF_BANK.FN_GETDAYS('20120101', '20121217') AVG
 18                    from t_pm_acct_dtl_af t1
 19                   whe