Does anyone have good link to an explanation of the graphical "Explain Plain" in Oracle's SQL Developer.
I'm not an Oracle SQL developer, and having trouble understanding their display of a "Nested Loop" - I can't seem to figure out what the outer loop is and what the inner loop is, and how to make it use an index, or hash join.
I currently have something similiar to the following, numbers to indicate tree level:
(0) NESTED LOOPS
(1)-NESTED LOOPS
(2)--NESTED LOOPS
(3)---HASH JOIN
(4)---HASH JOIN
(4)---TABLE ACCESS
(3)---TABLE ACCESS
(2)--INDEX
(1)-TABLE ACCESS
I'm not an Oracle SQL developer, and having trouble understanding their display of a "Nested Loop" - I can't seem to figure out what the outer loop is and what the inner loop is, and how to make it use an index, or hash join.
I currently have something similiar to the following, numbers to indicate tree level:
(0) NESTED LOOPS
(1)-NESTED LOOPS
(2)--NESTED LOOPS
(3)---HASH JOIN
(4)---HASH JOIN
(4)---TABLE ACCESS
(3)---TABLE ACCESS
(2)--INDEX
(1)-TABLE ACCESS