with as 干掉谓词推入

SQL> explain plan for select  count(1)
  2    from v48_transaction_model m
 where 1 = 1
   and m.trandate = date'2017-01-15'
   and 1 > 0
   /*and m.dsacctname like :3*/
   and 1 > 0
   and 1 > 0
   and not exists (select 1
          from t00_user_info t, t48_party p, v48_account a
         where t.idcardnumber = p.ca10crdid
           and p.ca10cno = a.ca10cno
           and m.acctnum = a.ad10acno)
   and 1 > 0  3    4    5    6    7    8    9   10   11   12   13   14  ;

Explained.

SQL> select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 3361881582

--------------------------------------------------------------------------------------------------------------------------