How to rebuild oracle index?

Question

484 views16/07/2022Oracle Database

0

Amen1.09K 20/02/2022 0 Comments

How to rebuild an Oracle index and the advantage of rebuilding an index?

Sample Examples of SQL statement to rebuild an index.

meda Changed status to publish 16/07/2022

Write your answer.

score 0 · Answer 1 · 2022-02-21T05:25:28+00:00

We rebuild an index either to make corrupted or unused index usable again or to change the tablespaces of the index for storage performance purposes.

We use the REBUILD clause for rebuilding an index:

SQL> ALTER INDEX <indexname> REBUILD;

OR

SQL> ALTER INDEX <indexname> REBUILD TABLESPACE <new-tablespace-name>;