Tuning with Materialized Views

Materialized views are one of the single most important SQL tuning tools and they are a true silver bullet, allowing you to pre-join complex views and pre-compute summaries for super-fast response time. This is a brief introduction to tuning with materialized views, but I've devoted over a hundred pages to SQL tuning with materialized views in my book "Oracle Tuning: The Definitive Reference".

Materialized views perform miracles in our goal to reduce repetitive I/O. Materialized views were first introduced in Oracle8, and in Oracle9i MV's were enhanced to allow very fast dynamic creation of complex objects. Materialized views allow sub-second response times by pre-computing aggregate information, and Oracle9i dynamically rewrites SQL queries to reference existing materialized views. In this article, we continue our discussion of materialized views and discuss how to set up and configure your Oracle database to use this powerful new feature. We begin with a look at the initialization parameters and continue with details of the effective management and use of materialized views.

Continue reading about tuning with materialized views:

http://dba-oracle.com/art_9i_mv.htm
 

*****************************************

Need a Health Check?

Oracle is the worlds most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

Burleson Consulting has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call 800-766-1884 for details, and check-out our on-site Oracle training catalog at the following link:

http://www.dba-oracle.com/bc-catalog.pdf