Explain difference between view and materialized view?
- 1 Answers
- 1058 Views
- I also Faced
- E-Mail Answers
Answer Posted / Mahesh Kumar
"A view is a virtual table in a database that contains the result set of an SQL query. When a user accesses a view, the database executes the underlying query to retrieve the data. A materialized view, on the other hand, is a pre-computed and physically stored version of a view. This allows for faster query performance because the data does not need to be recomputed each time the view is accessed."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how to generate iqd file from framework manager?
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?
What is the purpose of Dataware Control?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
