Re: Thank you ! Re: Is there any Faster workaround ??

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.