RE: What is the difference between view and materializ...
view - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes.
materialized view - stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query, the stored result set is used. Pros include quick query results.
RE: What is the difference between view and materializ...
hi,VIEW : This is a PSEUDO table that is not stored in the database and it is just a query.MATERIALIZED VIEWS: These are similar to a view but these are permantely stored in the database and often refreshed. This is used in optimization for the faster data retrieval and is useful in aggregation and summarization of data.
RE: What is the difference between view and materializ...
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.
RE: What is the difference between view and materializ...
View is a logical reference to a database table. But Meterial View is actual table and we can refresh data in time intervels. If you made any change in database table that change will effect into view but not meterialize view..
