| 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
This is one of the few statements that can make use of the nologging option.
Alter index ... rebuild
This is one of the few statements that can make use of the nologging option.
Alter index ... rebuild partition
This is one of the few statements that can make use of the nologging option.
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.
|