Thread

Re: [HACKERS] Slow - grindingly slow - query

Vadim Mikheev <vadim@krs.ru> — 1999-11-12T05:52:29Z

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