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