-
can anyone explain what is a materialize view?
is it a 8i feature or does it exist before?
thanks
-
Materialized views are used mostly on big tables,partition tables dss applications .
On big tables when you want max,min,average ,sum of certain values it takes a lot of times.
with Materialized views these things can be done pretty fater.
Materailazed views gater these datas and keep them on a snapshot. so when a querry asks sum(sal).
it takes the value from snapshot and gives the information.
Rather than sum all the values when the querry is proccessed.
pls look for more information on manuals.
Radhakrishnan.M
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
|