Disable an Index

Disable an Index example

To disable an oracle database index you must use the command alter index with unusable keyword. The status of index will change from valid to unusable.

  

-- disable Index using UNUSABLE
ALTER INDEX STU_LN_IDX UNUSABLE;

Output:

index STU_LN_IDX altered.

Check indexes

select INDEX_NAME, INDEX_TYPE, STATUS
from USER_INDEXES
WHERE table_name='STUDENTS_LIST';

Output:

INDEX_NAME	INDEX_TYPE	STATUS
STUDENT_IDX	NORMAL	VALID
STU_LN_IDX	NORMAL	UNUSABLE

↑