|
-
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
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
|