Re: Restructure is as fast as export, clear, load, calc
Posted Oct 7, 2011 8:17 PM
I guess the factors one should look at are:
- database size
- block size
- sparsity of data
I would think a very dense database could be defragmented faster using an export/import process. While a very sparse database might restructure faster.
This is just conjecture. I haven't actually run any tests. In practice, I just use the method that is fast enough. I usually try the restructure first because it's a single step.