On Wed, Apr 10, 2002 at 12:24:26PM +0200, Bernd von den Brincken wrote:
> >> > 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?
The IN construct is slow in Oracle and probably other RDBMSs too. I don't
know if the PostgreSQL implementation is any slower than others (I don't
think it is).
-Roberto
--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
The more things change, the more they stay the same.