Database DataWarehousing (MOSC)

MOSC Banner

Materialize View performance issue

edited Dec 3, 2012 10:53PM in Database DataWarehousing (MOSC) 5 commentsAnswered
Hi,

   We have created Materialize View with join if around 10 tables, we are doing complete refresh, it is talikng more than 2 hrs to refresh. But If I ran for one day, it is completing with in 2 seconds, Is there any way to do the Incremental refresh.

Thanks

Ram

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