What is the SKIP_UNUSABLE_INDEXES parameter?

What is the SKIP_UNUSABLE_INDEXES parameter?

Rating:

SKIP_UNUSABLE_INDEXES is a parameter used to enable or disable the optimizer to skip unusable indexes or index partitions. Some of the properties of the parameter are given below:

• Parameter type: Boolean
• Default value: true
• Modifiable: ALTER SESSION, ALTER SYSTEM
• Range of values: True | False

If the value of the parameter is set to true, it disables error reporting of the indexes and the index partitions marked as UNUSABLE. On the contrary, if the value is set to false, it enables error reporting of the indexes marked as UNUSABLE.

Rating: