SQL Performance (MOSC)

MOSC Banner

can global index be alter to invisible?

edited Feb 12, 2016 4:08AM in SQL Performance (MOSC) 3 commentsAnswered

RDBMS 11.2.0.4, need to evaluate if a local index will bring better performance than the current global index, we plan to alter the global index to invisible, and then create a new local index with additional column, if the local index does not bring better performance, we will simply drop the local index and alter the original global index to visible. I was told that global index cannot be alter to invisible, but was not find any doc to confirm this.  The following test case shows it is feasible though

create table test (id number, col1 varchar2(10))

tablespace users

partition by range (id)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center