Trace: • Oracle Database - TO_NUMBER function • Oracle Database - Trace File • Oracle Database - Transactions • Oracle Database - Transaction table - Interested transaction list (ITL) • Trigger • Oracle Database - Two-Task Common (TTC) protocol • Oracle Database - SQL Processing - How Oracle Database processes SQL statements? • Oracle Database - UNDO • Oracle Database - UNIQUE Constraints • Oracle Database - UNUSABLE index

You are here: Home » Database management system (DBMS) » Oracle Database » Oracle Database - UNUSABLE index

Oracle Database - UNUSABLE index

About

The index that are marked UNUSABLE can be skipped with the session parameter skip_unusable_indexes.

gerardnico@orcl>alter INDEX big_table_idx unusable;
 
INDEX altered.

Articles Related

database/oracle/unusable.txt · Last modified: 2010/07/20 17:50 by gerardnico