What is Materialized View, What is its utility?
Answers
Answered by
1
Answer:
In computing, a materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary using an aggregate function.
Answered by
2
Answer:
Good morning friend.
how are you?
Explanation:
- Materialized Views are used when data is to be accessed frequently and data in table not get updated on frequent basis.
- A materialized view is a database object that contains the results of a query.
- It store data based on remote tables are also, know as snapshots.
keep smiling.
Similar questions