Optimize Question

[altenbernd 0]

I've recently noticed that optimize is freeing up space when I don't think it should be.

 

I run optimize, which frees up some space. This is expected.

 

Then I run VFI and find no errors.

 

I run optimize again and free up some space.

 

I run it again and the difference is 0.

 

I run VFI again with no errors.

 

Run Optimize and the difference is 110, 671 bytes.

 

I can keep toggling between the VFI and the optimize. The optimize difference is 110,671 each time.

 

Is it normal for VFI to do something that would release some space even though it didn't identify any errors? Is this cause for concern? I haven't noticed any other problems, but I don't want to ignore this and then discover I have something corrupted in my database.

 

Thanks,

 

Sheila Altenbernd

[Jim Byram 0]

You are making the assumption that Optimize is removing space from the data tables which is not necessarily the case.

 

VFI 'fattens' the tables or indexes when it is running. Optimize removes that. Almost all of the space that Optimize removes is coming from the indexes. You have no idea how much (or if any) space Optimize removes from the data tables.

[altenbernd 0]

I was basing that on the before and after figures.

 

Thanks for explaining that VFI is "fattening" and that what I am seeing is normal.