On 11g, Does Rebuilding An Invisible Index Make It Visble?
(Doc ID 1088079.1)
Last updated on FEBRUARY 22, 2019
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.1]
Information in this document applies to any platform.
Beginning with Release 11g, you can create invisible indexes. An invisible index is an index that is ignored by the optimizer unless you explicitly set the OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter to TRUE at the session or system level. Making an index invisible is an alternative to making it unusable or dropping it. Using invisible indexes, you can do the following:
* Test the removal of an index before dropping it.
* Use temporary index structures for certain operations or modules of an application without affecting the
Question is, does rebuilding an Invisible index, makes it Visible?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document