Re: Using bind variables for multiple values
Date: Mon, 24 Nov 2008 16:12:56 +0100
Robert Klemme schreef:
> I wondered: why is it that the join version does a full table scan but > the IN ( subselect ) version does not?
From a logical point of view I would say: because what you ask for is
- For an IN clause, 1 occurence is enough to decide if there's a match - For a join, you specifically ask for all matching occurences.
Shakespeare Received on Mon Nov 24 2008 - 09:12:56 CST