Database DataWarehousing (MOSC)

MOSC Banner

Maintenance Operations on Materialized Views

edited Jan 14, 2010 12:54AM in Database DataWarehousing (MOSC) 2 comments
originally posted by User15004  (but as a Document)


We see some performance benefit in using Materialized Views in our OLTP environment. We are using MV logs and ROWID MVs - in the absence of explicitly defined primary keys on the base tables - understand that it is advisable not to use ROWID MVs.

Looking out for information about the maintenance activities that need to be carried out for MVs - yet to find the same in the docs.  In the meantime, I thought I could raise it up here so that those who are using MVs in their environment can share their experience on the same.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center