Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Explain Plan Question
I am curious as to how to interpret this explain plan. I know the basics, but does the following mean that it first does a FTS of PERSONAL_DATA, then with all those rows probes the JOB index, or does it mean that for each row retrieved during the FTS, it probes the index, one at a time, as it retrieves each one from PERSONAL_DATA? I realize it doesn't matter terribly in the end, I am just wondering what's it's actually doing behind the scenes. Thanks for any replies.
SELECT STATEMENT Optimizer=RULE
NESTED LOOPS
TABLE ACCESS (FULL) OF PS_PERSONAL_DATA
INDEX (RANGE SCAN) OF PSBJOB (NON-UNIQUE)
Received on Mon Mar 26 2001 - 17:38:07 CST
![]() |
![]() |