Received: from grynet.passagen.se (grynet.passagen.se [195.163.107.36]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA82024 for ; Mon, 1 Nov 1999 14:04:47 -0500 (EST) (envelope-from osk@hem.passagen.se) Received: from oskar (d212-151-111-242.swipnet.se [212.151.111.242]) by grynet.passagen.se (8.8.6/8.8.6) with ESMTP id UAA14193 for ; Mon, 1 Nov 1999 20:04:45 +0100 (MET) Received: from usel by oskar with local (Exim 3.03 #1 (Debian)) id 11iMlk-0001ud-00 for ; Mon, 01 Nov 1999 20:05:28 +0100 Date: Mon, 1 Nov 1999 20:05:28 +0100 From: Oskar Liljeblad To: pgsql-sql@postgresql.org Subject: Re: [SQL] query with subquery abnormally slow? Message-ID: <19991101200528.A7338@oskar> References: <19991101194707.A7034@oskar> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0pre4i In-Reply-To: <19991101194707.A7034@oskar>; from osk@hem.passagen.se on Mon, Nov 01, 1999 at 07:47:07PM +0100 On Mon, Nov 01, 1999 at 07:47:07PM +0100, Oskar Liljeblad wrote: > I'm doing a SELECT query with a subquery on a table with 12K rows > but it is very slow (10 seconds+). The query looks like this: Ok, I should have read the latest FAQ and checked the mail archive before posting this. I've read about the EXISTS-workaround, but it seems it can't be applied to my query because it deals with one table only. Or can it? Oskar Liljeblad (osk@hem.passagen.se)