Re: Performance of request of type WHERE ... IN ( ... )

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, Th Templ <templ_th(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Performance of request of type WHERE ... IN ( ... )
Date: 2003-01-15 17:17:28
Message-ID: web-2314793@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Th,

> > I have performance problem of an request of type ... WHERE ... IN (
> ... ).
> > How to improve performance of this type of request when a group of
> id in the
> > 'in' is important.
>
> Try WHERE ... EXISTS (...).

The explanation of the difference btw. IN and EXISTS is in the
PostgreSQL FAQ on the web site.

-Josh

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Crawford 2003-01-15 17:19:43 Re: index on to_char(created, 'YYYY') doesn't work
Previous Message Achilleus Mantzios 2003-01-15 16:12:15 Re: index on to_char(created, 'YYYY') doesn't work