Postgres Pro
Downloads
Home   >   mailing lists

Re: Bad query plan inside EXISTS clause - Mailing list pgsql-performance

From Yeb Havinga
Subject Re: Bad query plan inside EXISTS clause
Date
Msg-id 4B97A3C8.6000509@gmail.com
Whole thread Raw
In response to Re: Bad query plan inside EXISTS clause  (Kenneth Marshall <ktm@rice.edu>)
Responses Re: Bad query plan inside EXISTS clause  (Yeb Havinga <yebhavinga@gmail.com>)
List pgsql-performance
Tree view 
Kenneth Marshall wrote:
> EXISTS matches NULLs too and since they are not indexed a
> sequential scan is needed to check for them. Try using
> IN instead.
>
This is nonsense in more than one way.

regards
Yeb Havinga

pgsql-performance by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Bad query plan inside EXISTS clause
Next
From: Yeb Havinga
Date:
Subject: Re: Bad query plan inside EXISTS clause