获取执行计划的方法
时间：2010-10-28 来源：zhangyjd
1、通过DBMS_XPLAN.DISPLAY 获取
| EXPLAIN PLAN FOR SELECT * FROM (SELECT * FROM ZYJ_INV_BJK_FAFANGMINGXI_VIEW) QRSLT WHERE (TRANSACTION_DATE >= :1 AND TRANSACTION_DATE - 1 < :2) SELECT * FROM TABLE(dbms_xplan.display); |
| set autotrace trace exp; SQL> select * from dual; |
相关阅读 更多 +
