State the difference between View and Materialized View ?5
1062 5b5cc6cfe4d2b4197774e2e8
Q: State the difference between View and Materialized View ?
- Show Answer
- Workspace
- Discuss
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.
Similar Questions
Since Nithya and Suganya exchange places, so Rita’s new position is the same as Monika’s earlier position. This position is 17th from the right and 10th from the left. Therefore Number of girls in the row = (16 + 1 + 9) = 26.