Join Examsbook
799 0

Q: State the difference between View and Materialized View ?

  • Show AnswerHide Answer
  • Workspace

Answer :
Explanation :

The main differenc between View and Materialized View states that - 1. View means it stores the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes. 2. Materialized view means it stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query, the stored result set is used. Advantage include quick query results.

Are you sure

  Report Error

Please Enter Message
Error Reported Successfully
google play

The Most Comprehensive Exam Preparation Platform

Get the Examsbook Prep App Today