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
sk0227Asked:
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.
0
 
paquicubaCommented:
Do this:

alter index <index_name> invisible;

To make it visible:

ALTER SESSION | ALTER SYSTEM SET optimizer_use_invisible_indexes = TRUE

For more info: http://docs.oracle.com/cd/E11882_01/server.112/e25494/indexes004.htm#autoId3
0
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.