|
-
COMPLETE - All rows deletes and replaced.
FAST - Only changes in base table are transfered to the MVIEW, rather than replacing all the rows.
FORCE - A FAST is performed, if this cannot be done a COMPLETE is done.
You'll need to define material view logs to use a fast refresh and there are a number of restrictions.
Updatable is used if you want the MVIEW to be updatable, and the changes to be refleacted in the base table.
Query rewrite is necessary if you want Oracle to rewrite SQL statements to take advantage of available MViews if they would improve performance.
See:
http://otn.oracle.com/docs/products/...994/mv.htm#721
Cheers
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
|