Re: (2) Poor Performance with 7.31.uc6

Andy Lennard wrote: > > In article <8lq76b$hml$1@news.xmission.com>, Obnoxio The Clown > <obnoxio@hotmail.com> writes > > > >From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > >> > >>Obnoxio The Clown wrote: > >> > > >> > From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > >> > > > >> > >Andy Lennard wrote: > >> > > > > >> > > > Is there a utility to rebuild indexes? or is dbschema/dbaccess the > >>best? > >> > > > >> > >I would simply disable them, then enable them. You can do all indexes > >>on > >> > >a table with a single command. > >> > > >> > Fsck!!! You've been reading the manual again, haven't you? :-) > >> > >>Is that in the manual?! Well, I'm NOT as dumb as you thought! ;-) > > > >You'd be furniture if you were. :-) > > > >Andy, my script is still useful if you want to change fragmentation or > >placement. So there. :-) > > And it's certainly not clear from my reading of the manual that enabling > the index completely rebuilds it. > > It certainly does something (unless there's a big sleep in there > somewhere), but does it do enough to resolve the problem that we're > (I'm!) trying to sort out? Yes, it does rebuild your indexes. However, whether that solves your original problem I cannot say. I thought your original problem was a bug to do with index page priorities, and I thought the fix was to upgrade. But as ever, I could be wrong. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+