Maintaining and Monitoring Your Database : Managing Performance : Database fragmentation
Database fragmentation
Over time, as records are deleted from a database and new records are added, gaps can occur on the disk where the data is stored. This fragmentation can cause inefficient disk space usage and poor performance with sequential reads. You can eliminate fragmentation by dumping and reloading the database. You can manage fragmentation by changing create and toss limits.