On 11g, Does Rebuilding An Invisible Index Make It Visble?
Last updated on DECEMBER 06, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms