Re: [SQL] query with subquery abnormally slow? - Mailing list pgsql-sql

From Oskar Liljeblad
Subject Re: [SQL] query with subquery abnormally slow?
Date
Msg-id 19991101200528.A7338@oskar
Whole thread Raw
In response to query with subquery abnormally slow?  (Oskar Liljeblad <osk@hem.passagen.se>)
List pgsql-sql
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)




pgsql-sql by date:

Previous
From: Oskar Liljeblad
Date:
Subject: query with subquery abnormally slow?
Next
From: "Moray McConnachie"
Date:
Subject: Re: [SQL] query with subquery abnormally slow?