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

From: "Th Templ" <templ_th(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Performance of request of type WHERE ... IN ( ... )
Date: 2003-01-15 10:23:33
Message-ID: F79usluCBcKfExvWvqz0000a1be@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

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.
Thanks for your answers.
Templth

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Joseph Krogh 2003-01-15 11:37:05 index on to_char(created, 'YYYY') doesn't work
Previous Message Tambet Matiisen 2003-01-15 09:25:15 Re: full join in view