Re: De-fragmenting a table

From: "Neil Truby" <ntruby@netcomuk.co.uk> > >IDS v7.24 on HP-UX 10.20. > >I've got a 13GByte, 12 million row table in 175 extents and I need to >defrag >it. Urgently! > >I ran an ALTER TABLE FRAGMENT INIT last night and, fourteen hours later it >still hadn't finished. this was with logging temporarily turned off for >the >database. I only have a 12 hour downtime wondow. > >Any other ideas? I'm testing a High perfoamnce load but, although therows >take only 20 minutes or so, the indexes are going to be damned slow. Upgrade to a more recent version. :-) Indexes don't have to be damn slow to build: use PSORT_DBTEMP and PSORT_NPROCS and you might be impressed. :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com