On Fri, Aug 29, 2003 at 10:37:32AM -0400, Greg Stark wrote:
> Except if it guesses wrong by assuming it isn't selective it would be maybe
> 50% slower doing lots of index lookups instead of a more efficient full table
> scan and join. If it guesses wrong by assuming it'll be very selective as it
>
Greg Stark <[EMAIL PROTECTED]> writes:
> This is the same thing someone else pointed out a while ago. The consequences
> of guessing wrong and favouring a full table scan instead of index lookups
> with nested loops are simply much more severe than the reverse.
It is easy to demonstrate cases wher
