Explain materialized views and how they are used. | Oracle 10g Interview Questions

 Materialized views are objects that are reduced sets of information that have been summarized, grouped, or aggregated from base tables. They are typically used in data warehouse or decision support systems.