在现网环境下,很多时候要求不执行直接生成执行计划:
explain plan for
select *from (select (sum(1) over()) allnum, rownum rownum_, row_.*
from (select *
from zxdbm_870.s870_v_newvcdnnodepush
where (1 = 1)
and (vcdnid = '001')
order by vcdnid, destnodename) row_)
where rownum_ <= 10
and rownum_ > 0;
select * from table(dbms_xplan.display);