oracle查看执行计划

 

explain plan for
select/*+ full(t) */
count(1) from xpi_childinfo partition(xpchild01) t where t.cid is not null;

set timing on;
查看执行计划
select * from table(dbms_xplan.display());