Oracle Disable Index

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.

What is Index and Why Should We Use Index?

Do you want to learn Oracle Database Performance Tuning detailed, then Click this link.

Performance Tuning and SQL Tuning Tutorial in the Oracle Database