Take the 2-minute tour ×
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. It's 100% free, no registration required.

When refreshing materialised views does the index automatically refresh

share|improve this question
add comment

1 Answer

Yes.

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
1  
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
add comment

Your Answer

 
discard

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