执行计划查看-1

SQL> select empno,ename,rowid from scott.emp_cp where empno='7698';

     EMPNO ENAME      ROWID
---------- ---------- ------------------
      7698 BLAKE      AAACg+AAEAAAAE0AAF

SQL> select * from table(dbms_xplan.display_cursor(null,null,' ALL'));

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
SQL_ID ajmjp6syczm1k, child number 0
-------------------------------------
select empno,ename,rowid from scott.emp_cp where empno='7698'

Plan hash value: 2494534643

------------------------------------------------------------------------------------------------
| Id  | Operation    | Name       | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT    |       |       |       |     1 (100)|       |
|   1 |  TABLE ACCESS BY INDEX ROWID| EMP_CP       |     1 |    23 |     1 (0)| 00:00:01 |

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
|*  2 |   INDEX UNIQUE SCAN    | IDX_EMP_CP_EMPNO |     1 |       |     0 (0)|       |
------------------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------

   1 - SEL$1 / EMP_CP@SEL$1
   2 - SEL$1 / EMP_CP@SEL$1

Predicate Information (identified by operation id):
---------------------------------------------------

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------

   2 - access("EMPNO"=7698)

Column Projection Information (identified by operation id):
-----------------------------------------------------------

   1 - ROWID[ROWID,10], "EMPNO"[NUMBER,22], "ENAME"[VARCHAR2,10]
   2 - ROWID[ROWID,10], "EMPNO"[NUMBER,22]

31 rows selected.

SQL> 

SQL> select empno,ename,rowid from scott.emp_cp where rowid='AAACg+AAEAAAAE0AAF';

     EMPNO ENAME      ROWID
---------- ---------- ------------------
      7698 BLAKE      AAACg+AAEAAAAE0AAF

SQL> select * from table(dbms_xplan.display_cursor(null,null,'ALL'));

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
SQL_ID 89dmu6z5q084r, child number 0
-------------------------------------
select empno,ename,rowid from scott.emp_cp where rowid='AAACg+AAEAAAAE0AAF'

Plan hash value: 2228813866

-------------------------------------------------------------------------------------
| Id  | Operation   | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |    |    |    |  1 (100)|    |
|   1 |  TABLE ACCESS BY USER ROWID| EMP_CP |  1 | 23 |  1   (0)| 00:00:01 |

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------

   1 - SEL$1 / EMP_CP@SEL$1

Column Projection Information (identified by operation id):
-----------------------------------------------------------

   1 - ROWID[ROWID,10], "EMPNO"[NUMBER,22], "ENAME"[VARCHAR2,10]

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------

23 rows selected.

SQL> 

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------