----------------------------------------------------------
Plan hash value: 3364546307
---------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart | Pstop |
---------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 8 | 960 | 12 (0) | 00:00:01 | | |
| 1 | TABLE ACCESS BY GLOBAL INDEX ROWID| T65_F_S_PGZ10023_M | 8 | 960 | 12 (0) | 00:00:01 | ROWID | ROWID |
|* 2 | INDEX RANGE SCAN | I_T65_F_S_PGZ10023_M | 8 | | 3 (0) | 00:00:01 | | |
---------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("OBJKEY"='810000836')
Note
-----
- dynamic sampling used for this statement
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
12 consistent gets
32 physical reads
0 redo size
1182 bytes sent via SQL*Net to client
492 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
8 rows processed
objkey字段索引比较
Statistics
本地索引(LOCAL)
全局索引(GLOBAL)
recursive calls (递归调用)
32
0
db block gets (数据块)
0
0
consistent get (一致性读)
197
12
physical reads (物理读)
32
32
redo size
0
0
bytes sent via SQL*Net to client
1182
1182
bytes received via SQL*Net from client
492
492
SQL*Net roundtrips to/from client
2
2
sorts (memory)
0
0
sorts (disk)
0
0
rows processed
8
8
查看段的记录数: