How to Rebuild SQL Index Oracle 11G

Rebuilding indexes in your database can result in faster performance.

Oracle allows you to rebuild indexes using SQL commands. Rebuilding indexes can improves SQL performance and allows more free space. Index rebuilds can also be automated, but are often unnecessary. Analyze your database's performance before and after the rebuild to see what works better.

Instructions

1. Open a connection to the Oracle 11g database.

2. Create a SQL command of the following syntax, where index_name is the name of the index you want to rebuild: ALTER INDEX index_name REBUILD;

3. Execute the SQL command. The index will be rebuilt and a "Success" message should be returned.

Tips & Warnings

• Your database user must have the "Alter any index" system privilege in order to rebuild indexes. Ask your database administrator (DBA) if you do not have this privilege.

References

• Oracle documentation
• Oracle's Ask Tom forum