I asked this before, but did not see an answer.  I did a test
unload/load on my test server, and saw a 44% reduction in the database.
My selects ran with blazing speed, even on a much smaller box than the
production box.  What I wanted to know, from people that have seen
significant reductions, how long do the benefits last?  The database has
a percent changed of around 10% a day.  It seems like this could quickly
make these benefits "go away", but if the same, or close, 10% of the
database changes, the benefits might stay awhile.  I am trying to figure
out if I will need to do this again in 6 months, a year, or more, or
less.  Thanks for any info.  I know that, when I  do this, I will find
out myself, but we are not doing it til July 4th weekend, and I just
wanted to get some idea what other people are seeing.


Andy Carlson                                    |\      _,,,---,,_
Senior Technical Specialist               ZZZzz /,`.-'`'    -.  ;-;;,_
BJC Health Care                                |,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri                           '---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html