Materialized View Tuning

You can improve performance of materialized views.

• Limit Number of Join Rows

• Use Indexes on Join Columns

• Avoid Unnecessary Updates

• Avoid Changes to the Inner Table of an Outer Join

• Limit Number of Columns in a View Table