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