RE: Problem with statistics

From: Willaert Doris <doris.willaert@suzuki.be> > >1) Why so often ? Normally we did the update statistics once at night. But >we saw that after running a batch program early in the morning, the >optimiser chose the wrong path. What does the batch program do? >2) Yes, this is what we see. We also saw that there was a program running >that apparently does "bad written" selects. After this program was killed >and after we had done an update statistics, the select was ok again. We run >a simple update statistics. <PLUG> Have you tried my update stats shell script from http://www.iiug.org? It might make a better, more permanent solution. </PLUG> ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com