What is the REBUILD option of the ALTER INDEX statement?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the REBUILD option of the ALTER INDEX statement?
Rating:
The REBUILD option of the ALTER INDEX statement is used for rebuilding indexes. If an index is partitioned, it can rebuild a specified partition. This option requires availability of disk space because new indexes may also be present at the same time. It also requires a user to have the EXECUTE privilege on the index to be rebuilt. The option can also be used for moving an index to a different tablespace.
Rating:
Was this information helpful?
Other articles
- What is NOLOGGING clause?
- What are materialized views?
- What is least recently used (LRU) list?
- What is the use of DBMS_UTILITY package?
- What are bind variables?