Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 169DC475DA7 for ; Wed, 15 Jan 2003 05:26:06 -0500 (EST) Received: from hotmail.com (f79.law9.hotmail.com [64.4.9.79]) by postgresql.org (Postfix) with ESMTP id 59B67475CB1 for ; Wed, 15 Jan 2003 05:26:05 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 15 Jan 2003 02:23:33 -0800 Received: from 195.68.105.84 by lw9fd.law9.hotmail.msn.com with HTTP; Wed, 15 Jan 2003 10:23:33 GMT X-Originating-IP: [195.68.105.84] From: "Th Templ" To: pgsql-sql@postgresql.org Subject: Performance of request of type WHERE ... IN ( ... ) Date: Wed, 15 Jan 2003 11:23:33 +0100 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 15 Jan 2003 10:23:33.0642 (UTC) FILETIME=[283876A0:01C2BC80] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/205 X-Sequence-Number: 11070 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