Make index invisible - Oracle Database Script.
SQL>
SELECT VISIBILITY
FROM dba_indexes
WHERE index_name='IDX_SESS'
AND OWNER='AODBA';
VISIBILIT --------- VISIBLE SQL> ALTER INDEX AODBA.IDX_SESS INVISIBLE; Index altered. SQL> select VISIBILITY from dba_indexes where index_name='IDX_SESS' and owner='AODBA'; VISIBILIT --------- INVISIBLE -- Revert again to visible. SQL> ALTER INDEX AODBA.IDX_SESS VISIBLE; Index altered.