Home » Developer & Programmer » Data Integration » Materialize Views vs. Snapshot
Materialize Views vs. Snapshot [message #92850] Thu, 01 November 2001 08:12 Go to next message
Rafael Orta
Messages: 1
Registered: November 2001
Junior Member
Hi, is there any white paper that outline the differences in performance between materialize views and snapshots, I know there are some other advantages in using materilize views that could help me with performance like query rewrite, but I wonder if the basic functionality between an snapshop and a matelize view will get the same performance.

Any ideas will be appreciated.


Rafael Orta

Re: Materialize Views vs. Snapshot [message #92873 is a reply to message #92850] Sat, 01 December 2001 06:27 Go to previous message
Madhav Kasojjala
Messages: 42
Registered: November 2000
Hi Rafael,
As far as I know,
Oracle revamped the entire string of procedures required to operate Snapshots into one as Materialized view.
I don't think there is a difference at all as far as Oracle Engine is concerned.

Hope this helps

Previous Topic: Re: Heat Software
Next Topic: Error while deploying the pl/sql scripts
Goto Forum:

Current Time: Thu Dec 08 07:33:00 CST 2022