On Wed, Mar 20, 2013 at 9:53 AM, jg <jg@xxxxxxxx> wrote:
The rotated script, as explained, just drops tables and creates empty ones.
That doesn't make sense then, to have fragmentation if you are creating new tables with fresh data copied into them. The files should be pretty much sequentially written.
Ohhhh.... I see. You're using Windows. Maybe you need some OS with a better file system that doesn't fragment like that?