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);
原文：http://blog.csdn.net/jrainbow/article/details/44037017