Sql> SelectT1.* fromT1,t2whereT1.object_id=T2.object_id; Aboutrows selected. ExecutionPlan----------------------------------------------------------PlanHash value:1506669289---------------------------------------------------------------------------------------|Id|Operation|Name|Rows|Bytes|Cost (%CPU)| Time|---------------------------------------------------------------------------------------| 0 | SELECTSTATEMENT| | About | 16929 | 201(0)| xx:xx:Geneva || 1 |NESTED LOOPS| | About | 16929 | 201(0)| xx:xx:Geneva || 2 |NESTED LOOPS| | About | 16929 | 201(0)| xx:xx:Geneva || 3 | TABLEACCESS Full |T2| About | 1287 | 3(0)| xx:xx: on ||* 4 | INDEXRANGE SCAN|Idx_t1| 1 | | 1(0)| xx:xx: on || 5 | TABLEACCESS by INDEXROWID|T1| 1 | 158 | 2(0)| xx:xx: on |---------------------------------------------------------------------------------------predicate information (identified byoperation ID):--------------------------------------------------- 4 -Access ("T1". "object_id"="T2". "object_id") Note----- -Dynamic sampling used forThis statement ( Level=2)Statistics---------------------------------------------------------- 8Recursive calls0db block gets135consistent gets4Physical reads0Redo Size6108Bytes sent via SQL*Net toClient589Bytes received via SQL*Net fromClient8Sql*Net roundtrips to/ fromClient0sorts (memory)0Sorts (Disk) AboutRows processed
"Test" creates T1 and T2 tables in the HR user's own form to write an SQL statement (NL connection)