oracle執行計劃

oracle執行計劃

1、設置計劃

explain plan for 
select * from ( select * from  dun_search_view where 1=1 and (( salename='陳永智' and xsqy='廣州辦事處') or (','||fzuserid||',' like '%,6839951,%')) ) where rownum <= 30;

2、查詢計劃

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);