1. ToolsNet 8
2. Configuration
3. Working with the Database
4. ToolsNet Database Installer
5. Index Reorganize and Index Rebuild in Oracle

Index Reorganize and Index Rebuild in Oracle

Heavily fragmented indexes can decrease application and database performance. The Database Engine can be configured to automatically maintain indexes.

Index reorganize and Index rebuild are set up as a job in the Oracle Agent. The reorganize job should be run once a day on a database. With many transactions the rebuild job should be run once a week.

The index maintenance is set up with this schedule by default.