用EXPLAIN PLAN 分析SQL语句

使用工具：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