The database administrator’s responsibility includes rebuilding the indexes to improve performance of retrieving data and database searching. Perform this operation during off hours, as it requires exclusive access to the database tables.
 | Note: With Oracle Enterprise Edition, you can instead configure online reindexing. |
To reindex the Oracle Standard Edition database
Determine the space requirements for rebuilding the database.
Configure the index_upkeep.cfg configuration file for the amount of time you want index_rebuild to run.
Some weeks, no indexes may be rebuilt, depending on the REBUILD_FREQUENCY parameter.
If running Windows 64-bit, set the ORACLE_HOME environment variable by typing
set ORACLE_HOME=C:\oracle\product\10.2.0\db_1
Log into the Database Server as user oracle (Solaris) or AgfaService (Windows).
Type the reindex command
index_rebuild (Solaris)
or
bash index_rebuild (Windows)
After index_rebuild has completed successfully, back up the database.