Data Warehousing Question:

What is the difference between view and materialized view?

Tweet Share WhatsApp

Answer:

View - store the SQL statement in the database and let you use it as a table. Every time you access the view, the SQL statement executes. Materialized view - stores the results of the SQL in table form in the database. SQL statement only executes once and after that every time you run the query, the stored result set is used. Pros include quick query results.

Download Data Warehousing PDF Read All 131 Data Warehousing Questions
Previous QuestionNext Question
What is the main difference between Inmon and Kimball philosophies of data warehousing?What is the advantages data mining over traditional approaches?