I will explain Oracle Disable Index in this post.
Oracle Disable Index
Sometimes you may need disabling the existing index because of poor performance.
You can disable any index as follows.
ALTER INDEX SCHEMA_NAME.INDEX_NAME DISABLE; For example; MSDBA.TEST_INDEX can be disabled as follows.
ALTER INDEX MSDBA.TEST_INDEX DISABLE;
You can enable the disabled index with rebuild index option as follows.
ALTER INDEX SCHEMA_NAME.INDEX_NAME REBUILD;
ALTER INDEX MSDBA.TEST_INDEX REBUILD;
You should read the following post to learn more details about Oracle Index and Index operation in Oracle.
762 views last month, 4 views today