Oracle 索引扫描的4种类型

2014-11-24 17:44:23 · 作者: · 浏览: 0


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



| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Tim



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



| 0 | SELECT STATEMENT | | 1 | 207 | 2 (0)| 00:



| 1 | TABLE ACCESS BY INDEX ROWID| T | 1 | 207 | 2 (0)| 00:



|* 2 | INDEX UNIQUE SCAN | INDEX_T | 1 | | 1 (0)| 00:


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



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


2 - access("A"."OBJECT_ID"=75780)



统计信息
----------------------------------------------------------
6 recursive calls
0 db block gets
12 consistent gets
1 physical reads
0 redo size
1348 bytes sent via SQL*Net to client
404 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed


相关阅读: