First page Back Continue Last page Graphics

Continuation of Notes


Notes:

Notes continued from the previous page:

select /*+ ordered use_nl(small big) example6 */
small.created, big.owner
from big, small
where small.object_id=big.object_id

call count cpu elapsed disk query
------- ------ -------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0
Execute 1 0.00 0.00 0 0
Fetch 32428 6.19 6.24 0 632395
------- ------ -------- ---------- ---------- ----------
total 32430 6.19 6.24 0 632395

Rows Row Source Operation
------- ----------------------------------------------
486400 TABLE ACCESS BY INDEX ROWID SMALL
972801 NESTED LOOPS
486400 TABLE ACCESS FULL BIG
486400 INDEX RANGE SCAN SMALL_OBJECT_ID (object id

Refer to the supplied files nested_loops.sql, nested_loops_trace.txt and nested_loops_10053.sql for a demonstration of this and other nested loops concepts.