Hi!
I do have problem with update statistics. This update did take about 35 min and now take 1 hour. I did reorg the database and after that it did take 20 minuts and after a week it start agien to take 1 houer. well the data hase been increesed but it is not so much that give this effect.
Any body have an idee what kind of problem could be ?

Linux

Hi,
Please run update statistics in parallel process.

Gustavo.

Hi,
What you mean ? how I can do that ? I do have 4 CPU on this maskin and 3 of them is for informix databases.

Hi,
Arm a file with the sentences of update statistics by each table in all database and then divide into various files ".sql" and execute them with dbaccess in parallel.

Gustavo.

Thanks , now I understand what you mean. well it is a good idee. It should work, but what you think if you there is a diffrens between running update statistics for the whole database and update statistics for just applikations tables ? and what happend to the systables and other Informix tables ? do they need an update statistics ?