Re: Update Statistics and performance

williema@okzim.gaia.co.zw wrote: > I am running Online 5.08 on HP9000/UX 10.20. > The problem is every time I run Update statistics (which the manual > recommends I should do) performance goes down !. After running update > statistics the optimizer does not select the most efficient index, > even on simple queries !,) resulting in 2 second queries taking as much > 20 minutes (if you care to wait) !. I noticed, that when I recreate > the indexes the query costs go down and performance goes up. > This is clearly a bug !. Is every one running update statistics out there > and has any one come accross this ?. > If I can't fix this soon, my next upgrade (which is soon) will definately > not be Informix !. > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading I have ran the same configuration here for about a month while we where upgrading to 7.20 informix. I had no problems with update statistics, which I did run at least once a week. I would look someplace else for your problem. You must have sometype of weird configuration problem. ~D.