Re: Regarding INFORMIX Basic Details

Sunil Raja said:
> Hi,
>
>
> 1. why this command is taking more time ( its more than 30 minutes,
> the process is not over ), for just a database with 3 tables and no
> indexes
> ?
> How many rows in the tables? Bigger tables take more time.
>
> *just 1 or 2 rows in each of 3 tables, with no indexes. why is it taking
> so
> long to complete the update statistics.*

Are those the only three tables in the database?

> 2. If this command takes this much time, how can i check whether
> the statistics is working and how can i check whether the statistics of
> the table or index or database have been updated ?

onstat -g sql should show one or more sessions running UPDATE STATS.

> Well, I really, REALLY think you need to read the manual. You've been
sent
> the links.
>
> *Could you please tel me the link again ?*

http://www-306.ibm.com/software/data/informix/pubs/library/ids_94.html

This one probably first:
http://publib.boulder.ibm.com/epubs/pdf/ct1t9na.pdf

-- 
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."