Re: Question: UPDATE STATISTICS and CPU usage

In article <6b7e1u$7kn$1@news.xmission.com>, georg@cyberdude.com wrote: > > > While running UPDATE STATISTICS HIGH FOR table (colname) on a big > table we have the effect that nobody can connect to the informix engine > anymore (no matter to which database). We are running Informix 7.23 on a > single processor HP machine. It seems that it is not a locking problem. > Could it be that the Update Statistics statement uses up all the CPU > power? > Has anybody had similar experiences and had found a solution to the > problem? > > Thanks for your help, > GW Hi there, I am surprised this is still a problem in 7.23. I seen this in 7.20. The only way to avoid this situation is do not run update statistics while the DB is being used by user. I can see in the 7.23 release note that refer to bug # 62002 relating to update statistics. -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet