Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When refreshing materialised views does the index automatically refresh

share|improve this question


A refresh changes the table storing the data that is materialized from the materialized view query. The indexes for these tables are updated just as indexes for "normal" tables would be updated when they change.

share|improve this answer
An exception would be Oracle Text indexes for full text search (eg on CLOBS, PDFs etc) which require a synchronize operation. – Gary Mar 27 '11 at 23:24
@Gary Indeed, thanks for that addition. – Leigh Riffel Mar 28 '11 at 0:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.