Hi All
Can you tell me that why we use materlized view instead of Views.
I know that in Mat View data is populated at the time of creation as not in case of View.
Then what is the use of Mat view?
regards
praveen
Printable View
Hi All
Can you tell me that why we use materlized view instead of Views.
I know that in Mat View data is populated at the time of creation as not in case of View.
Then what is the use of Mat view?
regards
praveen
I can think of three reasons, there may be more ...
i) For replication, where we want to keep one database's data aligned with another
ii) To provide a consistent view, by updating an MV at fixed intervals, like once a day.
iii) To provide fast access to precomputed aggrege data.
I expect other people can think of other reasons.