1.创建PLAN_TABLE表
SQL> conn b2c20/b2c20
Connected.
SQL> @?/rdbms/admin/utlxplan.sql
Table created.
2.运行EXPLAIN PLAN
SQL> explain plan for
2 select count(*) from bc_customer;
Explained.
3.查看EXPLAIN PLAN
SQL> @?/rdbms/admin/utlxpls
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
---------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
---------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | |
| 1 | SORT AGGREGATE | | | | |
| 2 | TABLE ACCESS FULL | BC_CUSTOMER | | | |
---------------------------------------------------------------------
Note: rule based optimization
10 rows selected.
显然，这种方法查看执行计划比较麻烦。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10972173/viewspace-257155/ ，如需转载，请注明出处，否则将追究法律责任。
