Tuesday 22 December 2015

What is the difference between View and Materialized View?

A view is nothing but a virtual table which takes the output of the query and it can be used in place of tables.
 A materialized view is nothing but an indirect access to the table data by storing the results of a query in a separate schema.

No comments:

Post a Comment