Enterprise Data Warehouse Question:
Download Job Interview Questions and Answers PDF
Explain difference between view and materialized view?
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.
view : - View occupties memory to store query but not data.
Materilized view:- The view query results is stored in database knows as Materilized view.
view : - View occupties memory to store query but not data.
Materilized view:- The view query results is stored in database knows as Materilized view.
Download Enterprise Data Warehouse Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is data type of the surrogate key? | Explain the main difference between Inmon and Kimball philosophies of data warehousing? |