用EXPLAIN PLAN 分析SQL语句

来源：互联网发布：node实现反向代理跨域编辑：程序博客网时间：2024/04/30 11:25

使用工具：PL/SQL developer

t1是按照Oracle SQL 高级编程56页编写的

command window:

SQL> explain plan set statement_id='BJ1' for select * from t1 where gid='34';

Explained

Executed in 0 seconds

SQL>SELECT ID,PARENT_ID,A.cost,A.bytes, A.OPERATION,OPTIONS,OBJECT_NAME,OBJECT_TYPE FROM PLAN_TABLE a WHERE STATEMENT_ID='BJ1' ORDER BY Id;

                                   ID  　 PARENT_ID      COST   BYTES            OPERATION                   OPTIONS                         OBJECT_NAME           OBJECT_TYPE
                                    0                                        3         10300          SELECT STATEMENT
                                    1             0                      3         10300               TABLE ACCESS         BY INDEX ROWID              T1
                                    2              1                      1                                         INDEX                      RANGE SCAN                    T1_DEX1                        NON-UNIQUE

具体查看

http://space.itpub.net/127656/viewspace-364817