parallel_index不生效

select dealid,
       orderseqid,
       dealamount,
       dealstatus,
       dealcode,
       d.payeefee,
       d.payerfee,
       d.transactiondate,
       sysdate
  from david.test1 d
 where exists (select /*+ index_ffs(tfp) parallel_index(tfp 3)*/
         0
          from david.test2 tfp
         where d.orderseqid = tfp.sequenceid);

原因很簡單，因為內部索引是INDEX FAST FULL SCAN，索引必須先指定正確的索引掃描方式，然後並行掃描索引部分的hint才能生效