You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for query rewrite


1 to 20 of 5996 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Query Rewrite Considerations: ConstraintsMake sure all inner joins referred to in a materialized view have referential integrity (foreign key/primary key constraints) with additional NOT NULL constraints on the foreign key columns. Since constraints tend to impose a large overhead, you could make them NO VALIDATE and RELY and set the parameter QUERY_REWRITE_INTEGRITY to STALE_TOLERATED or TRUSTED. However, if you set QUERY_REWRITE_INTEGRITY

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Materialized Views

Query Rewrite RestrictionsQuery rewrite is not possible with all materialized views. If query rewrite is not occurring when … for rewrite. If this shows that not all types of query rewrite are possible, use the procedure … DBMS_ADVISOR.TUNE_MVIEW to see if the materialized view can be defined

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Query Rewrite

Overview of Query RewriteDatabase employs an extremely powerful process called query rewrite to quickly answer the query using … ability to take advantage of query rewrite, which transforms a SQL statement expressed in terms of … intervention and no reference to the materialized view in the SQL statement. Because query

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Query Rewrite

Accuracy of Query RewriteQuery rewrite offers three levels of rewrite integrity that are controlled by the session parameter … relationships specified using dimensions. This mode offers greater query rewrite capabilities but also creates … contain stale data as well as those that contain fresh data. This mode offers the maximum

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

18 Advanced Query RewriteThis chapter discusses advanced query rewrite topics in Oracle, and contains: How Oracle Rewrites … Queries Types of Query Rewrite Other Query Rewrite Considerations Advanced Query Rewrite Using … Equivalences Verifying that Query Rewrite

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Query Rewrite Considerations: HintsYou can include hints in the SELECT blocks of your SQL statements to control whether query rewrite … occurs. Using the NOREWRITE hint in a query prevents the optimizer from rewriting it. The REWRITE hint … with no argument in a query forces the optimizer to use a materialized view (if any) to rewrite

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

General Query Rewrite MethodsThe optimizer has a number of different types of query rewrite methods that it can choose from to … answer a query. When text match rewrite is not possible, this group of rewrite methods is known as … general query rewrite. The advantage of using these more advanced

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Materialized Views

Enabling Query RewriteBefore creating a materialized view, you can verify what types of query rewrite are possible by … materialized view so that many types of query rewrite are possible. Once the materialized view has been … rewrite facility. Even though query rewrite is enabled by default,

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Other Query Rewrite ConsiderationsThe following discusses some of the other cases when query rewrite is possible: Query Rewrite Using … Nested Materialized Views Query Rewrite in the Presence of Inline Views Query Rewrite Using Remote … Tables Query Rewrite

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Query Rewrite Considerations: DimensionsQUERY_REWRITE_INTEGRITY to TRUSTED or STALE_TOLERATED for query rewrite to take advantage of the relationships declared in dimensions.

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Query Rewrite Considerations: Statisticsthe materialized view and the tables in the query to make a cost-based choice. Materialized views

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Query Rewrite Considerations: AggregatesTo get the maximum benefit from query rewrite, make sure that all aggregates which are needed to … aggregates are quite similar to those for incremental refresh. For instance, if AVG(x) is in the query

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Query Rewrite

17 Basic Query RewriteThis chapter discusses query rewrite in Oracle, and contains: Overview of Query Rewrite Ensuring … that Query Rewrite Takes Effect Example of Query Rewrite

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Types of Query Rewriteoriginal tables. Query rewrite transforms an incoming query to fetch the results from materialized … answered almost instantaneously. For considerations regarding query rewrite of cube organized … used to rewrite a query: Text Match Rewrite Join Back

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Query Rewrite

Controlling Query RewriteA materialized view is only eligible for query rewrite if the ENABLE QUERY REWRITE clause has been … , ALTER SESSION can be used to disable or enable query rewrite for that session only. An example is … the following: ALTER SESSION SET QUERY_REWRITE_ENABLED = TRUE; You can set the level

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Partition Change Tracking (PCT) Rewritesales_in_1999_mv BUILD IMMEDIATE REFRESH FORCE ON DEMAND ENABLE QUERY REWRITE AS SELECT s.time_id … following query cannot be rewritten if multiple materialized view rewrite is set to off. Because … multiple materialized view rewrite is on by default, the following query is rewritten

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Query Rewrite in the Presence of Inline ViewsO racle Database supports query rewrite with inline views in two ways: when the text from the … how a query with an inline view can rewrite with a materialized view using text match and general … MATERIALIZED VIEW SUM_SALES_MV ENABLE QUERY REWRITE AS SELECT mv_iv.prod_id, mv_iv.cust_id,

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Advanced Query Rewrite Using EquivalencesThere is a special type of query rewrite that is possible where a declaration is made that two SQL … . This advanced rewrite capability can generally be applied to a variety of query performance problems … knowledge into the database so the database can exploit this knowledge for improved query performance

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Query Rewrite

Sample Schema and Materialized Viewsoptimizer uses data relationships to rewrite queries. The query rewrite examples in this chapter … sum_sales_pscat_week_mv ENABLE QUERY REWRITE AS SELECT p.prod_subcategory, t.week_ending_day, SUM … sum_sales_prod_week_mv ENABLE QUERY REWRITE AS SELECT p.prod_id, t.week_ending_day,

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Checks Made by Query RewriteFor query rewrite to occur, there are a number of checks that the data must pass. These checks are … Figure 18-2. Figure 18-2 Query Rewrite Subgraphs Description of \"Figure 18-2 Query Rewrite Subgraphs … joining key. Upon rewrite, the materialized view is joined to