Oracle Database - skip_unusable_indexes parameter

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;