filter 优化

SELECT COUNT(*)
  FROM T18_TASKLIST t1
 WHERE TASKTYPE || '-' || BUSINESSKEY || '-' || GRANULARITY NOT IN
       (SELECT TASKTYPE || '-' || BUSINESSKEY || '-' || GRANULARITY
          FROM T18_TASK_FACT t2
         WHERE STATISTICDATE = '2017-01-13')
   and t1.GRANULARITY not in ('4', '5', '7');


---高级执行计划:
11G：
set linesize 200;
set pagesize 200;
alter session set statistics_level=all; ---再运行SQL

select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'));


SQL> SELECT COUNT(*)
  FROM T18_TASKLIST t1
 WHERE TASKTYPE || '-' || BUSINESSKEY || '-' || GRANULARITY NOT IN
       (SELECT TASKTYPE || '-' || BUSINESSKEY || '-' || GRANULARITY
          FROM T18_TASK_FACT t2
         WHERE STATISTICDATE = '2017-01-13')
   and t1.GRANULARITY not in ('4', '5', '7');  2    3    4