Computer Science, asked by msvaity1, 7 months ago

What is Materialized View, What is its utility?

Answers

Answered by nijalasiju
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 amanbisht0034
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