parameter to disable/invisible indexes

Hello Experts,

i am looking for a parameter to disable/invisible all indexes in a database. could you please let me know if any parameter will the same task?
i am ok even if it is a hidden parameter
Who is Participating?
slightwv (䄆 Netminder) Commented:
ALL indexes in a database would also mean those on system tables.  That could be a bad thing.

Are you really after all indexes in a schema?

Anyway, I don't think such a thing exists.  You will need to write your own.

You will probably also need to make sure these indexes are not part of a constraint that enforces referential integrity.
Do this:

alter index <index_name> invisible;

To make it visible:

ALTER SESSION | ALTER SYSTEM SET optimizer_use_invisible_indexes = TRUE

For more info:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.