Re: 7.22.UC1X2 Performance tuning questions....

On 3 Apr 97 at 2:46, tony edwards wrote: > We don't have KAIO set because processor affinity is not supported on > HP. The two are not dependent on each other - set KAIO on and reduce the no of AIO VPs. > 4) System not using indexes correctly > > - Have run update statistics medium for all tables, update statistics > high on first column of > each index and run update statistics low on all other index fields. I thought "official policy" was USH for first index columns, USM for other index columns and USL for the rest. > 6) If we changed our optcompind to zero would we need to run so many > update stats? Yes. UPDATE STATS must be run early and often (depending on your database activity, of course) Regarding your checkpoints, aren't your log size perhaps too large, otherwise decrease the checkpoint interval. HTH. -- Ciao, Billy Nose to the ground and ear to the grindstone in: Johannesburg "Wow, that's a big word for an eight-year old!!"