Search SSWUG.ORG:

DATABASES

Invisible Indexes (Part 1) This is an off-site link.  Please review our Terms of Service for additional information.




(Andrew Reid) Oracle introduced INVISIBLE indexes in version 11. The example below creates an INVISIBLE index, makes it VISIBLE then makes it INVISIBLE again. The VISIBILITY column in USER_INDEXES is used to check that each change has worked:

Read this article...







comments powered by Disqus