SQL Snippets ™: Tutorials for Oracle Developers

Custom Search

Home SQL Features SQL Techniques Miscellany About Blog Site Map Search

Home

SQL Features
Materialized Views
	Views vs Materialized Views
	REFRESH COMPLETE
	Materialized View Logs
	REFRESH FAST
	Purging Materialized View Logs
	REFRESH FAST Categories
	EXPLAIN_MVIEW
	REFRESH FORCE
	NEVER REFRESH
	ON DEMAND
	ON COMMIT
	Constraints
	Indexes
	ENABLE QUERY REWRITE
	Query Rewrite Restrictions and Capabilities
	Join Queries
	Aggregate Queries
	Nested Materialized Views
	More Info
	Setup
	Cleanup

< Previous

Next >

Read Using SQL Snippets ™ before using any of this site's sample code or techniques on your own systems.

Materialized Views

More Info

We now have a basic understanding of materialized views and should be able to use them effectively in simple denormalization, validation, data warehousing, and replication applications. Readers requiring advanced materialized view features such as partitioning, refresh groups, and updatable materialized views may wish to follow these Oracle documentation links to learn more.

Nested Materialized Views

Setup

Linking to SQL Snippets ™

To link to this page in Oracle Technology Network Forums or OraFAQ Forums cut and paste this code.

[url=http://www.sqlsnippets.com/en/topic-12928.html]SQL Snippets: Materialized Views - More Info[/url]

To link to this page in HTML documents or Blogger comments cut and paste this code.

<a href="http://www.sqlsnippets.com/en/topic-12928.html">SQL Snippets: Materialized Views - More Info</a>

To link to this page in other web sites use the following values.

Link Text : SQL Snippets: Materialized Views - More Info
URL (href): http://www.sqlsnippets.com/en/topic-12928.html

Ads by NSC Cards

Terms and Conditions of Use Disclaimer Privacy Policy

This page was first published on March 19, 2008.

The views expressed on this site are my own and do not necessarily reflect the views of Oracle.