Q
Problem solve Get help with specific problems with your technologies, process and projects.

Refreshing a materialized view in 8i

We have a materialized view with indexes created on it in our 8i database, and we were discussing the following question: When the view is refreshed using complete method, does Oracle drop/disable the index and then recreate/rebuild them at the end? If not, should we be doing this ourselves?
If the index is not showing up as invalid after the refresh this is actually a moot point. If they are showing up as invalid then yes rebuild them, otherwise I would leave them alone.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close