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 materialized views


21 to 40 of 5476 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Rolling Materialized Viewsor list partitioned. PCT refresh is nonatomic. Rolling Materialized Views When a data warehouse or … tables or materialized views include a time dimension and are horizontally partitioned by the time … attribute, then management of rolling materialized views can be reduced to a few fast

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Query Rewrite

Sample Schema and Materialized ViewsThe following sections use the sh sample schema and a few materialized views to illustrate how the … mainly refer to the following materialized views. These materialized views do not necessarily represent … this chapter. The following materialized views

Database Data Warehousing Guide, 11g Release 2 (11.2)

Maintaining the Data Warehouse

Tips After Refreshing Materialized Viewsre-enable integrity constraints (if any) and refresh the materialized views and materialized view … materialized view data is redundant and can always be reconstructed from the detail tables, it might be … preferable to disable logging on the materialized view. To disable logging and run incremental

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Materialized Views for Mobile ComputingYou can also use materialized views to download a subset of data from central servers to mobile … focuses on the use of materialized views in data warehouses. See Oracle Database Advanced Replication

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Materialized Views Containing Only JoinsSome materialized views contain only joins and no aggregates, such as in Example 9-4, where a … inner join. See \"Restrictions on Fast Refresh on Materialized Views with Joins Only\" for more … information regarding the conditions that cause refresh performance to degrade. Materialized Join Views

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Materialized Views for Data WarehousesIn data warehouses, you can use materialized views to precompute and store aggregated data such as … the sum of sales. Materialized views in these environments are often referred to as summaries … aggregations. A materialized view eliminates the overhead associated with expensive joins and aggregations

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Materialized Views for Distributed ComputingIn distributed environments, you can use materialized views to replicate data at distributed sites … materialized views provide local access to data that otherwise would have to be accessed from remote … sites. Materialized views are also useful in remote data marts. See Oracle Database

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Materialized Views with Set OperatorsOracle Database provides support for materialized views whose defining query involves set operators … . Materialized views with set operators can now be created enabled for query rewrite. You can … marker. See \"Restrictions on Fast Refresh on Materialized Views with UNION ALL\" for

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Security Issues with Materialized ViewsTo create a materialized view in your own schema, you must have the CREATE MATERIALIZED VIEW … materialized view in another schema, you must have the CREATE ANY MATERIALIZED VIEW privilege and the … owner of the materialized view needs SELECT privileges to the tables referenced if they are from another

Database Concepts, 11g Release 2 (11.2)

Partitions, Views, and Other Schema Objects

Refresh Methods for Materialized ViewsThe database maintains data in materialized views by refreshing them after changes to their master … huge amounts of data. A fast refresh eliminates the need to rebuild materialized views from scratch … . Thus, processing only the changes can result in a very fast refresh time. Materialized views

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Choosing Indexes for Materialized Viewsdefined on each materialized view key column. In the case of materialized views containing only joins … The two most common operations on a materialized view are query execution and fast refresh, and … of the materialized view key columns, and might need to join and aggregate over a subset of those

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

The Need for Materialized ViewsYou can use materialized views to increase the speed of queries on very large databases. Queries to … determines how the materialized view is refreshed and used by query rewrite. Materialized views … and not to the underlying detail tables. In general, rewriting queries to use materialized

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Adding Comments to Materialized Viewsto data dictionary views for the existing materialized view: COMMENT ON MATERIALIZED VIEW sales_mv IS … You can add a comment to a materialized view. For example, the following statement adds a comment … 'sales materialized view'; To view the comment after the preceding statement execution, the user

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Benefits of Partitioning Materialized ViewsMaterialized views with multiple aggregate groups give their best performance for refresh and query … effective partitioning scheme for these materialized views is to use composite partitioning (range-list … on ( time, GROUPING_ID ) columns). By partitioning the materialized views this

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Overview of Data Warehousing with Materialized ViewsMaterialized views can perform a number of roles, such as improving query performance or providing replicated … summaries that had been defined. The database administrator creates one or more materialized views, which … . Although materialized views are usually accessed through

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Using Materialized Views with NLS ParametersWhen using certain materialized views, you must ensure that your NLS parameters are the same as … when you created the materialized view. Materialized views with this restriction are as follows … materialized view after a refresh operation. Expressions that generate internal conversion

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Materialized View Schema Designand you require fewer materialized views if your schema design complies with these guidelines. A … applications, so that a database administrator can create or drop materialized views at any time without … Summary management can perform many useful functions, including query rewrite and materialized

Database Data Warehousing Guide, 11g Release 2 (11.2)

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 … query. Even though a materialized view is defined, it will not automatically be used by the query … QUERY REWRITE

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Materialized Views in Analytic Processing Environmentsthese types of queries. It also illustrates the best approach for creating materialized views using a common scenario.

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Data Warehousing Terminologythe typical work load, can be used to create materialized views. See Chapter 11, \"Dimensions\" for … fact table, and each foreign key joins with exactly one row of a dimension table. A materialized view … tables. Among builders of data warehouses, a materialized view is also known as a summary.