-
Materialized View and View
Hi,
I need to know the acutal difference between Views and Materialized view.
Thanks
-
Hi,
i try to
* Views are stored SQL-Queries, but no view-data is stored.
* Mviews are stored SQL-Quries to local or far objects, the view-data is stored locally and refreshed by specific interval. Mviews are not new, they derived from snapshots.
Oracle uses Mviews for more, for example with query-rewrite to speed up aggragated data-access.
Orca
-
views are stored SQL
mviews are physical tables, like snapshots need to get refreshed at certain time, full or incremental, they are also used by the optimizer to accomplish query rewrites
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
|