Search SSWUG.ORG:

DATABASES

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




(Andrew Reid) In Oracle 11.1.0.6.0, you could not run DBMS_STATS against an invisible index or a table with an invisible index. I found 2 workarounds. You could run the old ANALYZE command or you could make the index visible on a temporary basis:

Read this article...







comments powered by Disqus