What Are The Best Practices Of Creating Materialized Views?

1.	What Are The Best Practices Of Creating Materialized Views?
Answer» Create materialized views with few columns which are frequently queried. Specify ORDER by clause on the most RESTRICTIVE columns (columns USED in where clause). Periodically or manually REFRESH the materialized views.

Answer»

Create materialized views with few columns which are frequently queried.
Specify ORDER by clause on the most RESTRICTIVE columns (columns USED in where clause).
Periodically or manually REFRESH the materialized views.

Discussion