Explain the difference between view and materialized view?
- 1 Answers
- 1002 Views
- I also Faced
- E-Mail Answers
Answer Posted / Suman Shukla
A View is a virtual table created by a SELECT statement that does not store data but instead provides a representation of data from one or more tables in a database. A Materialized View, on the other hand, is a pre-computed and stored version of a view. It physically stores the result set of a query for faster access.n
1. Query Execution:n - View: The SELECT statement is executed every time the view is accessed.n - Materialized View: The data is already pre-computed and stored, so it does not require computation each time it's accessed (faster performance).n
2. Data Consistency:n - View: Since it's a virtual table, there may be a slight delay in retrieving the most up-to-date data.n - Materialized View: The data is updated periodically using refresh functions to ensure data consistency.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of Dataware Control?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Explain how to generate iqd file from framework manager?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
