Invisible Indexes performance-wise
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.