GeekArticles
Database
Oracle


Improve Results with Query Rewrite
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?
Sponsored Links
Read Next: Grasping for Data
Related Topics
Subscribe via RSS
Oracle
- Guide to Linux File Command Mastery
- Improve Results with Query Rewrite
- Grasping for Data
- Tracing SQL in Oracle Database 10g
- The Top 20 Technical Articles and Columns of 2003
- Compressing Data for Space and Speed
- Oracle Database 10g: The Top 20 Features for DBAs
- Fine-Grained Auditing for Real-World Problems, Part 2
- Controlling Mythological Code
- Using the JSP 2.0 EL API