Luke Tudor - RSG wrote:
> I seem to have a small problem with my nested queries. Im sure its
> something so simple; If I run each query seperatly, I get the correct
> results and these results can be put into the parent query.
> However if the queries are run together as one nested query the results
> hours and hours (more like days).
FAQ: 4.23) Why are my subqueries using IN so slow?
(Use EXISTS instead of IN)
GPG-Key available at http://www.sayegh.de
(see http://www.gnupg.org for details)
In response to
pgsql-novice by date
|Next:||From: Paul Joseph McGee||Date: 2001-01-17 14:10:36|
|Subject: Type Creation|
|Previous:||From: John Poltorak||Date: 2001-01-17 12:29:31|
|Subject: Re: What am I doing wrong?|