Materialized view data fetch from source table and move to the target .

Question

Accepted Answer

Materialized view data is fetched from source table and moved to target.

Materialized view is a precomputed table that stores the result of a query.
Data is fetched from the source table and stored in the materialized view.
The materialized view is updated periodically to reflect changes in the source table.
This process is useful for improving query performance.
Example: A materialized view can be created to store the total sales for each product category.
The data from the sales table is fetched and stored in the materialized view.
Queries for total sales by product category can then be run against the materialized view instead of the sales table.
This reduces the amount of time needed to compute the result.

Popular interview questions of Deputy Manager