Explain difference between view and materialized view?
Submitted by: AdministratorView - 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.
Submitted by: Administrator
view : - View occupties memory to store query but not data.
Materilized view:- The view query results is stored in database knows as Materilized view.
Submitted by: Administrator
Read Online Enterprise Data Warehouse Job Interview Questions And Answers
Top Enterprise Data Warehouse Questions
☺ | Explain What is the advantages data mining over traditional approaches? |
☺ | What are the main steps to build the data warehouse? |
☺ | Explain the different types of data warehousing? |
☺ | Explain the main differences between star and snowflake schema? |
☺ | Explain the main difference between Inmon and Kimball philosophies of data warehousing? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |