2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
7 rows processed
SQL> select /*+index(range idx_nonpre)*/ id,name,address from range where name='OUTLN'; --使用索引
21 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 279219031
-----------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
-----------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 21 | 672 | 11 (0)| 00:00:01 | | |
| 1 | PARTITION RANGE ALL | | 21 | 672 | 11 (0)| 00:00:01 | 1 | 4 |
| 2 | TABLE ACCESS BY LOCAL INDEX ROWID| RANGE | 21 | 672 | 11 (0)| 00:00:01 | 1 | 4 |
|* 3 | INDEX RANGE SCAN | IDX_NONPRE | 2 | | 5 (0)| 00:00:01 | 1 | 4 |
-----------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
3 - access("NAME"='OUTLN')
Note
-----
- dynamic sampling used for this statement
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
14 consistent gets
0 physical reads
0 redo size
867 bytes sent via SQL*Net to client
396 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
21 rows processed
作者 aqszhuaihuai