Re: Regarding INFORMIX Basic Details

Sunil Raja said:
> Are those the only three tables in the database?
> Yes. It took more than 30 minutes, still the update statistics process
> didnt
> get completed. why is it taking so long time ?

So you have only three tables in the database, each with only a handful of
rows in and update statistics is taking more than 30 minutes?

I'm not going to call you a liar, but I am curious. :o)

Run this:

time dbaccess yourdatabasename <<!
update statistics;
!

And tell me what it says.

-- 
Bye now,
Obnoxio

"There were a myriad of problems which conspired to corrupt your reason
and rob you of your common sense. Fear got the best of you, and in your
panic you turned to the Labour Party. They promised you order, they
promised you peace, and all they demanded in return was your silent,
obedient consent."