Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4676D9FA2CC for ; Wed, 13 Dec 2006 15:02:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 53287-04 for ; Wed, 13 Dec 2006 15:02:03 -0400 (AST) X-Greylist: delayed 00:19:17.602279 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A89839FA2FD for ; Wed, 13 Dec 2006 15:02:04 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.optiosoftware.com (mail.optio.com [192.216.93.10]) by svr4.postgresql.org (Postfix) with ESMTP id 2CDC35AF91A for ; Wed, 13 Dec 2006 18:42:46 +0000 (GMT) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: strange query behavior Date: Wed, 13 Dec 2006 13:42:20 -0500 Message-ID: <47668A1334CDBF46927C1A0DFEB223D39F79A5@mail.optiosoftware.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: strange query behavior Thread-Index: Acce5mvkXOiDIHL7RLeJO1dd4ZBhGw== From: "Tim Jones" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.52 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO, SPF_SOFTFAIL X-Spam-Level: * X-Archive-Number: 200612/333 X-Sequence-Number: 22389 Hi, I have a query that uses an IN clause and it seems in perform great when there is more than two values in it but if there is only one it is really slow. Also if I change the query to use an =3D instead of IN in = the case of only one value it is still slow. Possibly I need to reindex this particular index? thanks=20 Tim Jones Healthcare Project Manager Optio Software, Inc. (770) 576-3555