On Mon, Dec 15, 2003 at 12:14:17 -0500, Prashant Dalal <pdalal@laborlogix.com> wrote:
> Hi,
>
> My Following select st. is running from last one day. I think the problem is
> NOT IN clause.
> Please suggest the alternative select clause.
NOT IN was especially slow up until Postgres 7.4. If using 7.4 is a problem
you can rewrite your query to use NOT EXISTS.