SQL Performance (MOSC)

MOSC Banner

Invisible Indexes performance-wise

edited Feb 6, 2015 10:01AM in SQL Performance (MOSC) 3 commentsAnswered

Hi,

I learnt recently through the DBA of one of our clients that in 11g was introduced the concept of INVISIBLE index.

He kind of claimed that invisible indexes could improve performances in some cases.

So I looked at the documentation :

Understand When to Use Unusable or Invisible Indexes

http://docs.oracle.com/cd/E11882_01/server.112/e25494/indexes.htm#ADMIN13279

After reading the part on invisible index, I'm not conviced one could befenit performance-wise from an invisible index.

I rather see an "administrative" benefit. Indeed, if for example I disable a local index (UNUSABLE option), then I have to rebuild each of its partitions one by one.

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