Improve Results with Query Rewrite

Author: oracle.com | Published: 10th Aug 2005 | Visited: 904 times | Add Comment
Filed in: Oracle

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 Article

Sponsored Links

• Sql query Sir, I have joined this team having severe problems with SQL and found one having excessive CpU from AWR reports. There are many changes that we have suggested to this insert, could you please give your valuable inputs also please. On a 10G i ...

• Query string encryption for ASP.NET Clear text query strings are a potential security threat for your web application. Thus, query strings should be always encryp ...

• Use encoded query string with ASP.NET In order to improve the security of ASP.NET web applications, query strings should be always encryp ...

• Query Hi Tom, I definetly remember seeing something similar to this on this site, but could not find. If I am right, could you direct me to the link please? Thank you, Sinan here is my question. <code> -- Create table create table ASKTOM_TA ...

• Convert Query Result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report This utility is used for convert query result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report, supported SQL Server and ODBC connect ...

• See search results as you type - An ASP.NET Ajax Control A searchbox that updates the page with search results as you t ...

• ODP.NET - Techniques to Improve Performance while Retrieving Data ODP.NET - Techniques to Improve Performance while Retrieving Data Performance tuning is a great subject in Oracle. Volumes of books would not be enough to cover every aspect of performance tuning in Oracle. However, in this section, we will only discuss the fundamental performance techniques while.. ...

• How to query miniport driver information (802.11 OIDs) using DeviceIOControl() function? Query 802.11 OIDs using DeviceIOControl from a .NET-C# applica ...

• Modifying LINQ Expressions with Rewrite Rules Rewriting query expressions is a simple and yet a safe and powerful technique to modify queries dynamically in runt ...

• sqlTunes - Query Your iTunes Library sqlTunes is a small tool that exports iTunes library information to the SQL ser ...

Next: Guide to Linux File Command Mastery