Nested Loops
The nested loop is the original join access path. In this case, Oracle designates one of the tables as the driving table. Unless there is an index on the driving table that can be used to reduce the number of rows chosen, Oracle performs a full table scan on the driving table. It then uses an index to retrieve rows based upon the WHERE clause from the second table.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
