In this article you'll find out what materialized views are, what they can do and, most importantly, how they work - a lot of the ' magic ' goes on behind the scenes. Having gone to the trouble of creating it, you'll find out how to make sure that your materialized view is used by all queries to which the view is capable of providing the answer. Sometimes, you know Oracle could use the materialized view, but it is not able to do so simply because it lacks important information.

    View Tutorial

Detailed Information      Tutorial: The Secrets of Materialized Views      Date Listed: 2005-02-06      Submitted By: iidavidii      Total Hits: 4410      Rating (463 votes)

•  Comment On Tutorial

•  View Tutorial   •  Report Broken Link