| Materialize Views vs. Snapshot [message #92850] |
Thu, 01 November 2001 08:12  |
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.
Sincerely
Rafael Orta
----------------------------------------------------------------------
|
|
|
|
| Re: Materialize Views vs. Snapshot [message #92873 is a reply to message #92850] |
Sat, 01 December 2001 06:27  |
Madhav Kasojjala
Messages: 42
Registered: November 2000
|
Member |
|
|
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
Sincerely
Madhav
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
