Re: Oracle using indexes

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 8 Feb 2000 19:20:47 GMT
Message-ID: <38A06C8F.6EA6D0@edcmail.cr.usgs.gov>

> You didn't include the results of your explain plan but I would guess
> that the join is accomplished by using a Nested Loop join. If that is
> the case, then the second table in your FROM clause is the driving table
> and the driving table needs to have a full table scan performed on it.
> If TBL1 is smaller than TBL2, then reverse the order in the FROM clause.

I'm printing a minor retraction here. I should have said that the driving table OFTEN has a full table scan performed on it. This isn't always the case.

HTH,
Brian Received on Tue Feb 08 2000 - 13:20:47 CST