Oracle says that a well defined set of materialized views can be made to cover a whole schema, but that is easier said than done. Resourceful DBAs know about the SQLTuning Advisor, but the wisest are always on the lookout for techniques they can use to find all opportunities for materialized views.
Materialized views are one of the single most important SQL tuning tools.
They are a true silver bullet, allowing the DBA to pre-join complex views and pre-compute summaries for super fast response time.
Read more about how to use your existing workload to determine the best materialized view for super fast response time:
more
Find opportunities for materialized views
