MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: Massive Reorg



fixed

I only gained between 4 and 5 percent by this reorg.

System ASP . . . . . . : 326.2
% system ASP used . . : 64.081

Some reorgs can take awhile. This one was running with no interactive or
batch jobs running:
Job 339929/ROB/GLH started on 10/22/12 at 11:38:39
Job 339929/ROB/GLH ended on 10/22/12 at 12:20:27;
Didn't really have that many deleted rows (at least compared to some of
the heavy hitters). Active rows are significant, 25,715,052.


Rob Berendt





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact