SQL> select t1.* from t1,t2 where t1.object_id=t2.object_id; 99 rows selected. Execution Plan
----------------------------------------------------------
Plan hash value: 1506669289 --------------------------------------------------------------------------------
------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Tim
e | --------------------------------------------------------------------------------
------- | 0 | SELECT STATEMENT | | 99 | 16929 | 201 (0)| 00:
00:03 | | 1 | NESTED LOOPS | | 99 | 16929 | 201 (0)| 00:
00:03 | | 2 | NESTED LOOPS | | 99 | 16929 | 201 (0)| 00:
00:03 | | 3 | TABLE ACCESS FULL | T2 | 99 | 1287 | 3 (0)| 00:
00:01 | |* 4 | INDEX RANGE SCAN | IDX_T1 | 1 | | 1 (0)| 00:
00:01 | | 5 | TABLE ACCESS BY INDEX ROWID| T1 | 1 | 158 | 2 (0)| 00:
00:01 | --------------------------------------------------------------------------------
------- Predicate Information (identified by operation id):
--------------------------------------------------- 4 - access("T1"."OBJECT_ID"="T2"."OBJECT_ID") Note
-----
- dynamic sampling used for this statement (level=2) Statistics
----------------------------------------------------------
8 recursive calls
0 db block gets
135 consistent gets
4 physical reads
0 redo size
6108 bytes sent via SQL*Net to client
589 bytes received via SQL*Net from client
8 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
99 rows processed