hint UNNEST 可以提示CBO进行Subquery Unnesting

用hint NO_UNNEST 可以禁止CBO 进行 Subquery Unnesting 
   hint UNNEST 可以提示CBO进行Subquery Unnesting
   上面HINT只能放在子查询里面

select count(*) as col_0_0_
  from WF_PUB_FORM_DATA pubformdat0_
 where (1 = 1)
   and (pubformdat0_.ID in
       (select distinct pubformcas1_.FORM_ID
           from WF_PUB_FORM_CASE pubformcas1_
          where (pubformcas1_.CASE_ID in
                ((select to_char(caserun0_.ID)
                     from CASE_RUN caserun0_, WORKITEM_RUN workitemru1_
                    where (caserun0_.ID = workitemru1_.CASEID)
                      and (caserun0_.STATE = 2)
                      and (workitemru1_.PERFORMER in ('300016/00415'))
                      and (workitemru1_.VALID_FLAG = '0')) union all
                 (select to_char(caserun2_.ID)
                     from CASE_RUN caserun2_, WORKITEM_HISTORY workitemhi3_
                    where (caserun2_.ID = workitemhi3_.CASEID)
                      and (caserun2_