Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Richard harnden — — source: Informix-list mailing list archive (1991-1998)
Why not have your batch program update the stats _properly_ for whatever
table(s) it changes ?
>>> "Obnoxio The Clown" <obnoxio@hotmail.com> 03/28/00 10:34am >>>
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.