Horton

Re: [HACKERS] Slow - grindingly slow - query

Vadim Mikheev <vadim@krs.ru>

View thread
From: Vadim Mikheev <vadim@krs.ru>
To: Theo Kramer <theo@flame.co.za>
Cc: pgsql-hackers@postgreSQL.org
Date: 1999-11-12T05:52:29Z
Lists: pgsql-hackers 
Theo Kramer wrote:
> 
> > Try something like
> >
> >   select accountdetail.domain from accountdetail where
> >     not exists (select accountmaster.domain from accountmaster where
> >                 accountmaster.domain = accountdetail.domain);
> 
> This takes 5 seconds - wow!

> I did the same on Informix Online 7 and it took less than two minutes...
                                                            ^^^^^^^^^^^
Could you run the query above in Informix?
How long would it take to complete?

Vadim