On 2016-11-22 07:37, Jean Laeremans wrote:
Well i beg to differ. Each year i create a warehouse app out of some txt files generated by a mf. They are in the +1gb class. Afterwards i delete the indexes and create new ones. New ones are about 1/3 smaller.
What percentage of records were marked as delete? I'm 100% sure it had to do with that. I guess my experience is different because in my systems, the percentage of deleted records is very small.