Do you know what is the materialized view? Materialized view is a snapshot of a query.
Do you know what’s the difference on defining materialized view vs. regular view ? There are differences in six elements like Definition, Storage, and Query Execution. This brief article lists the key differences in an easy to comprehend manner.
Do you know what types of data is the best candidate to be defined in materialized views? The data is static and less likely change frequently such as configuration data.
Do you know how much performance improvement we will get when utilizing materialized view?
Read a helpful post on Stack Overflow for all the details.
Materialized view is not a view but a database table. There is no insert, update, delete on the materialized view, and it is good for read only. The content of the materialized view needs to be refreshed periodically, especially, when there is data insert, update, delete on the underneath tables/views which are related to the SQL definition of the materialized view. There is a maintenance page in PeopleSoft allows you to schedule the materialized view refresh.
Stay tuned for a detailed blog on the topic of Materialized View!