Oracle Database - skip_unusable_indexes parameter

Card Puncher Data Processing

About

skip_unusable_indexes is a parameter which permit to skip the maintenance of the index that are marked as unusable.

gerardnico@orcl>alter session set skip_unusable_indexes=true;





Discover More
Card Puncher Data Processing
Oracle Database - How can we load a large number of rows into an indexed existing table ?

If you have to perform data load into a or data mart, you must skip the index to minimize the generation of redo log, such as : set the indexes to the state. They are not dropped but just setting...
Card Puncher Data Processing
Oracle Database - Index (indices)

in Oracle Create Statement for columns table: The LOGGING/NOLOGGING setting determines if operations are...
Card Puncher Data Processing
Oracle Database - Why you have still a lot of redo and archive ? The Index side effect.

You use the direct path insert and set the logging mode as NOLOGGING but you have still a lot of redo log generated. Why ? The answer is that you have an index on the table, and the index cannot just...



Share this page:
Follow us:
Task Runner