Skip site navigation (1) Skip section navigation (2)

Re: Question about subselect/IN performance

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "T(dot)H(dot)" <calinet6(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Question about subselect/IN performance
Date: 2010-11-30 22:54:55
Message-ID: 4CF52C5F0200002500037FBA@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
"T.H." <calinet6(at)gmail(dot)com> wrote:
 
> Also, are there any better ways you can think of doing such an IN
> query, using non-subselect means that might be more efficient?
 
Have you tried the EXISTS predicate?
 
-Kevin

In response to

Responses

pgsql-performance by date

Next:From: Mario SplivaloDate: 2010-11-30 23:22:33
Subject: Re: SELECT INTO large FKyed table is slow
Previous:From: Pierre CDate: 2010-11-30 22:35:04
Subject: Re: Simple database, multiple instances?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group