Postgres Pro
Downloads
Home   >   mailing lists

Optimizer for IN (..) ? / Re: Thank you ! Re: Is there any Faster workaround ?? - Mailing list pgsql-sql

From Bernd von den Brincken
Subject Optimizer for IN (..) ? / Re: Thank you ! Re: Is there any Faster workaround ??
Date
Msg-id 5.1.0.14.2.20020410122013.01cfdec0@pop.kundenserver.de
Whole thread Raw
In response to Thank you ! Re: Is there any Faster workaround ??  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: Thank you ! Re: Is there any Faster workaround ??  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-sql
Tree view 
Hello,

At 09.04.2002 23:32, Rajesh Kumar Mallah <mallah@trade-india.com> wrote:
>i think this question has been answered before also in
>this mailing list  sorry for asking...
>...
> > How about:
> >
> > DELETE  from t_a where exist (select email from t_b where t_b.email =
> > t_a.email)
> >
> > Rajesh Kumar Mallah wrote:
> > > ... We require to do below or similar quite often
> > >
> > > DELETE  from t_a where email in (select email from t_b);
> > >
> > > everyone knows "IN" is pain fully slow currently in pgsql
> > > is the any fster alternative to above query

Yes this question was posted before - and if so, and if the answer is so 
simple - would it not make sense to implement this wisdom in the optimizer?
Regards
// Bernd vdB

pgsql-sql by date:

Previous
From: "Pierre-Andre Michel"
Date:
Subject: How to use an index on a bigint column
Next
From: "Camila Rocha"
Date:
Subject: oid and oidvector