3 Rebuild data and index files
Completely rebuilds the database data and index file, bringing all data up to the latest generation
Advantages
- May significantly improve database performance
- Reduces the size of the database data file, possibly dramatically.
- Provides greater security than option 1 in the event of a system crash
- The free space is released to the operating system
- Results in a better organised database than option 1
Disadvantages
- Whilst in progress, this option requires enough disk space for an additional copy of the data file
- Requires a little more time than option 1. On large databases this is very unlikely to be a significant proportion of the total time required.
User Interrupt
Not available
Crash Recovery
Yes (see Reorganising with Rebuild )
When to use
Whenever prompted by the system to do a database reorganisation