Re: Bloody ERP schema

Hi, Thanks for your reply nonetheless I have already run high level update statistics on the entire database. Unfortunatly, it was without effect. Secondly, we always test a new version of informix on a test machine before to upgrade in production. Thanks a lot for help ! "Neil Truby" <neil.truby@ardenta.com> wrote in message news:<baa0gh$qmevo$1@ID-162943.news.dfncis.de>... > Update stats? > Also, the optimiser is prone to change its workings between releases, and we > always receommend to clients that it's very important to test out critical > processes on the new release *before* upgrading... >

Oxow wrote: > Hi, > > Thanks for your reply nonetheless I have already run high level update > statistics on the entire database. Unfortunatly, it was without > effect. > Don't run update statistics high on the whole database. You should run the commands as mentioned in the docs (high on first index column, ...). You may use Art Kagel's programm dostats (it's in the package named utils2_ak at iiug).