| explain plan [message #372436] |
Tue, 13 February 2001 14:32  |
meena
Messages: 36
Registered: December 2000
|
Member |
|
|
Hi,
I used explain plan on a query and this is the output from the plan_table
QUERY_PLAN
-------------------------------------------------------
NESTED LOOPS
----MERGE JOIN CARTESIAN
---------TABLE ACCESS BY INDEX ROWID ANALOG_TEST
-------------INDEX RANGE SCAN AT_TEST_NUMBER_01
----------SORT JOIN
-------------TABLE ACCESS FULL MFG_LOCATION
----TABLE ACCESS FULL ANALOG_RESULT
I'm not sure about how to read the above result from the plan_table (the order in which it has to be read). Can Anyone help me with this?
Thanks!
Meena
|
|
|
|
| Re: explain plan [message #372438 is a reply to message #372436] |
Tue, 13 February 2001 14:59  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi,
From the Jason Couchman Book...
The execution plan is interpreted in the following way.
Inermost rows are the first events taking place in the execution plan. From there, the plan is evaluated from the inside out, with the results from the inner operations feeding as input to the outer operations.
Bala
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
