Re: Optimizer taking too long to determine query path -- finally SOME performance improvement

What version of Informix are you running? We've found a bug in 7.30.UC7 where the optimizer gets confused by UPDATE STATISTICS HIGH and MEDIUM for various tables. Due to issues here, I continue to run update stats high and medium, and eliminate a table from the mix when I determine that there's a problem. Also looking for a fix for the bug in the 7.30 series as well. John Carlson Informix DBA WHSmith USA katherinec wrote: > > Thanks to you and everyone else who has been providing feedback. > > A few of you suggested that I try update statistics low drop > distributions. I did this and the queries that were taking >50000 > seconds are now executing in less than 100 seconds!!!! > > I still think I have a way to go... I am meeting with the users > tomorrow to determine which indexes are no longer necessary and to get > a better idea of the kinds of queries that are likely. Also thrown > into this mix is there is blob and varchar data in these tables. > > So I will... > - get rid of unnecessary indexes to eliminate some overhead > - further evaluate where I should run update statistics low, med, high > (medium and high does negatively impact some performance... I need to > figure out why) and evaluate when I should keep or drop distributions > and set up a NEW update statistics script to be run once a week. > > Thanks again for all of your help!!!! > > Surf Usenet at home or on the road -- always at Talkway. > http://www.talkway.com