-
Why we use materilzed 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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|