What is the difference between view and materialized view ?
Normal Views are for Access purpose ie One need to give access the end user to specific data.
Materialized Views are to optimize the performance . WHen materialzied view are used in the queries ,stored results are fetched (Instead of fecthing from individual talbes) which improves the performance. Refreshing option for materialised view can be set.