在现网环境下,很多时候要求不执行直接生成执行计划:
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);

被折叠的 条评论
为什么被折叠?



