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


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


Database Concepts, 12c Release 1 (12.1)

Partitions, Views, and Other Schema Objects

Overview of Materialized Viewsobjects. The FROM clause of the query can name tables, views, or materialized views. A materialized … . Materialized views summarize, compute, replicate, and distribute data. They are suitable in various computing … environments, such as the following: In data warehouses, materialized

Database Concepts, 12c Release 1 (12.1)

Partitions, Views, and Other Schema Objects

Characteristics of Materialized ViewsMaterialized views share some characteristics of indexes and nonmaterialized views. Materialized … data in other tables and views. Unlike indexes, users can query materialized views directly using … the materialized view. See Also: Oracle Database Data

Database Concepts, 12c Release 1 (12.1)

Partitions, Views, and Other Schema Objects

Refresh Methods for Materialized ViewsThe database maintains data in materialized views by refreshing them after changes to the base

Database SQL Tuning Guide, 12c Release 1 (12.1)

Query Transformations

Query Rewrite with Materialized Viewsmaterialized views that are compatible with the user query, and then selects one or more … materialized views to rewrite the user query. The use of materialized views to rewrite a query is cost-based … . Thus, the optimizer does not rewrite the query when the plan generated unless the

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Schema Objects

18.2.3 Validating Tables, Indexes, Clusters, and Materialized ViewsTo verify the integrity of the structure of a table, index, cluster, or materialized view, use the … table, index, or cluster is corrupt, then drop it and re-create it. If a materialized view is corrupt … not corrected, then drop and re-create the materialized view. The following statement analyzes the emp

Database Data Warehousing Guide, 12c Release 1 (12.1)

Refreshing Materialized Views

About Refreshing Materialized ViewsThe database maintains data in materialized views by refreshing them after changes to the base … all of their materialized views at the same time: as soon as some underlying detail data has been … updated, all materialized views using this data become stale. Therefore, if you defer refreshing

Database Data Warehousing Guide, 12c Release 1 (12.1)

Basic Materialized Views

Dropping Materialized ViewsUse the DROP MATERIALIZED VIEW statement to drop a materialized view. For example, consider the … following statement: DROP MATERIALIZED VIEW sales_sum_mv; This statement drops the materialized view … sales_sum_mv. If the materialized view was prebuilt on a table, then the table is not dropped, but it

Database Data Warehousing Guide, 12c Release 1 (12.1)

Advanced Materialized Views

Altering Materialized Viewssecurity implications for materialized views accessed in this way are much the same as for indexes: all … . Restrictions with Materialized Views and Virtual Private Database Query rewrite does not use its … you directly specify when you create the materialized view. Altering Materialized

Database Data Warehousing Guide, 12c Release 1 (12.1)

Basic Materialized Views

5 Basic Materialized ViewsThis chapter describes the use of materialized views. It contains the following topics: Overview of … Data Warehousing with Materialized Views Types of Materialized Views Creating Materialized Views … Creating Materialized View Logs

Database Data Warehousing Guide, 12c Release 1 (12.1)

Basic Materialized Views

About Materialized Views Names, you might consider extending this naming scheme to the materialized views so that they are easily … The name of a materialized view must conform to standard Oracle naming conventions. However, if the … materialized view is based on a user-defined prebuilt table, then the name of the materialized view

Database Data Warehousing Guide, 12c Release 1 (12.1)

Basic Materialized Views

Registering Existing Materialized ViewsSome data warehouses have implemented materialized views in ordinary user tables. Although this … solution provides the performance benefits of materialized views, it does not: Provide query rewrite to … all SQL applications. Enable materialized views defined in one application to be

Database Data Warehousing Guide, 12c Release 1 (12.1)

Advanced Materialized Views

About Compressing Materialized Viewsforeign keys. In particular, materialized views created with the ROLLUP clause are likely candidates … \" About Storage And Table Compression for Materialized Views \" for details regarding compression

Database Data Warehousing Guide, 12c Release 1 (12.1)

Advanced Materialized Views

Invalidating Materialized ViewsDependencies related to materialized views are automatically maintained to ensure correct operation … views is not tracked. Thus, if you use remote materialized views for rewrite, they are considered to be trusted. … . When a materialized view is created, the materialized

Database Data Warehousing Guide, 12c Release 1 (12.1)

Basic Materialized Views

Creating Materialized ViewsWhy Use Nested Materialized Views? In a data warehouse, you typically create many aggregate views … distinct materialized aggregate views can take a long time, because the underlying join has to be … performed many times. Using nested materialized views, you can create

Database Development Guide, 12c Release 1 (12.1)

Design Basics

1.9.2 Materialized ViewsMaterialized views are query results that have been stored (\"materialized\") as schema objects … . Like tables and views, materialized views can appear in the FROM clauses of queries. Like tables … , materialized views can be partitioned (see \"Partitioning\"

Database Data Warehousing Guide, 12c Release 1 (12.1)

Basic Materialized Views

Types of Materialized ViewsFROM clause of a SELECT statement), subqueries, and materialized views can all be joined or referenced … , such as in the WHERE clause. The types of materialized views are: About Materialized Views with … Aggregates About Materialized Views Containing

Database Data Warehousing Guide, 12c Release 1 (12.1)

Advanced Materialized Views

6 Advanced Materialized ViewsThis chapter discusses advanced topics in using materialized views. It contains the following … topics: About Partitioning and Materialized Views About Materialized Views in Analytic Processing … Environments About Materialized Views and Models Invalidating

Database Data Warehousing Guide, 12c Release 1 (12.1)

Advanced Materialized Views

Rolling Materialized Viewsbe range or list partitioned. PCT refresh is nonatomic. Rolling Materialized Views When a data … fact 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

Database Data Warehousing Guide, 12c Release 1 (12.1)

Refreshing Materialized Views

7 Refreshing Materialized ViewsThis chapter discusses how to refresh materialized views, which is a key element in maintaining … good performance and consistent data when working with materialized views in a data warehousing … environment. This chapter includes the following sections: About Refreshing Materialized Views

Database Data Warehousing Guide, 12c Release 1 (12.1)

Basic Materialized Views

About Nested Materialized ViewsMaterialized Join Views FROM Clause Considerations If the materialized view contains only joins … = c.cust_id(+) AND s.time_id = t.time_id(+); About Nested Materialized Views A nested materializedviews. This section contains the following topics: Why Use Nested Materialized