SQL> select x from t where x = 4523423; --第一次执行
已用时间: 00: 00: 00.15
执行计划
----------------------------------------------------------
Plan hash value: 1572208108
----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 5 | 3 (0)| 00:00:01 |
|* 1 | INDEX RANGE SCAN| IND_T_X | 1 | 5 | 3 (0)| 00:00:01 |
----------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("X"=4523423)
统计信息
----------------------------------------------------------
279 recursive calls
0 db block gets
44 consistent gets
9 physical reads
0 redo size
404 bytes sent via SQL*Net to client
385 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
5 sorts (memory)
0 sorts (disk)
1 rows processed
SQL> select x from t where x = 4523423; --第二次执行
已用时间: 00: 00: 00.00
执行计划
-----------------------------------------------------