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

(Andrew Reid) In Oracle, 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