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