EXPLAIN PLAN

1. 创建plan

EXPLAIN PLAN SET statement_id = 'Plan_ID' FOR 

SELECT * FROM Table_Name;

 

2. 查询结果

方法1: SELECT * FROM table (DBMS_XPLAN.DISPLAY);

方法2: SELECT * FROM PLAN_TABLE WHERE STATEMENT_ID = 'Plan_ID';