Tuesday, 6 August 2013

Rebuilding matviews

Rebuilding matviews

Can someone clarify whether we should rebuild mat views if an index is
added to the source table ?
We have an existing "table->mv" setup and for performance reasons we have
decided to add an index to the table.Should I have to drop and recreate
the matview again ?

No comments:

Post a Comment