Tech Tutorials Database
GeekArticles Database Oracle
 

Improve Results with Query Rewrite

 
Author: oracle.com
Category: Oracle
Comments (0)

This article introduces the types of query rewrites the optimizer can perform. It then discusses tools to help determine the best set of materialized views to create for enabling the optimizer to rewrite many queries. Materialized views created using these tools are also fast-refreshable when the underlying data on which the materialized view is based changes. If you don't know whether it would be better to create a materialized view, an index, or both, the SQL Access Advisor, introduced in Oracle Database 10g, can help you decide by analyzing a given workload.Are you tired of waiting for your queries to return results? Have you already tried adding indexes and tuning the SQL, and still can't improve query performance? Well, have you considered creating materialized views?

Read More...




Sponsored Links




Read Next: Grasping for Data



 

 

Comments



Post Your Comment:

Your Name:*
e-mail ID:(required for notification)*
Image Verification:�
 
 Subscribe