Re: Explain Plan Question

Hi Buck.

Basically it means this:

for each row in ps_personal_data loop

    lookup the value in psbjob
    join them together
end loop

Dave

PL/SQL is one of Oracle's most underutilized features

"Buck Turgidson" <jc_va_at_spamisnotcool.hotmail.com> wrote in message news:zpQv6.199735$Z8.42300152_at_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 - 22:48:18 CST