Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Explain Plan Question

Explain Plan Question

From: Buck Turgidson <jc_va_at_spamisnotcool.hotmail.com>
Date: Mon, 26 Mar 2001 23:38:07 GMT
Message-ID: <zpQv6.199735$Z8.42300152@typhoon.southeast.rr.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US