Oninit cdi / Archive
Talk to an expert →

Re: (2) Poor Performance with 7.31.uc6

Posted in 2000

Topics: Performance & Tuning, Server Administration

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

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. :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

↪ replying to Obnoxio The Clown
Andy Lennard — — source: Informix-list mailing list archive (1991-1998)

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? >__________________________________ >______________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > Andrew Lennard andy@kontron.demon.co.uk

Glossary