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 ?
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 ?