Unanswered: Optimization not clearing all fragments
During the optimization of my database there is a significant amount of 'Level 2 data fragments' (red) fragments remaining after optimization. Approximately, 1/10 of the data, as estimated by looking at the visual bar graph, is showing that it is still a 'Level 2' fragment after running the optimization. Is this any reason to be concerned? Is there a way to force Brilliant Database to de-fragment the program?
1: Make a copy of your database.
2: Rename the copy you made to a single word no longer than 8 letters.
3: Open the copy of your database and run the Maintenance Advanced / Check on it.
4: Now run the De-fragment.
I have been following your earlier recommendations regarding optimization/defragmenting though I never used the Advanced Check on it. Before attempting that scary option, I tried one more time for the regular 'Optimization' and it worked fine today. I am really curious as to why it would not remove all fragments last evening (after repeated attempts) but it works smoothly today???