Re: btree percentages at 95%

Posted in 1999

Obnoxio The Clown — Sun, 05 Dec 1999 12:51:24 GMT — source: Informix-list mailing list archive (1991-1998)

From: Doug McAllister <doug.mcallister@nospam.fmr.com> > >We have been analyzing the performance of a particular job and I was >wondering if anyone has insight into the following question. > >The analysis shows that the buffers have 96% btree data and only 3% >data. Might this be a symptom of the index bug which shows up in systems >that have been migrated from 7.24 to 7.31? Yep. Look into NOLRUPRIO, try dropping and recreating all indexes and dropping and recreating all statistics. Or upgrade to a newer version. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com