|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
Alter index in Oracle
Alter index ... split partition
Alter index ... rebuild
Alter index ... rebuild partition
alter index ... unusable
.... Yet to be finished ....
See also using the +append hint with insert statements for a possible use to set an index to unusable.
alter index ... [no]monitoring usage
An index can be monitored to verify if it is used within the period between
SQL>alter index index_name monitoring usage; -- and SQL>alter index index_name nomonitoring usage;
The result is stored in v$object_usage.
See also On verifying if an index is used.