How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Overview of Materialized Views → objects. 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
Characteristics of Materialized Views → Materialized 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
Refresh Methods for Materialized Views → The database maintains data in materialized views by refreshing them after changes to the base
Query Rewrite with Materialized Views → materialized 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
18.2.3 Validating Tables, Indexes, Clusters, and Materialized Views → To 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
About Refreshing Materialized Views → The 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
Dropping Materialized Views → Use 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
Altering Materialized Views → security 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
5 Basic Materialized Views → This 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
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
Registering Existing Materialized Views → Some 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
About Compressing Materialized Views → foreign 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
Invalidating Materialized Views → Dependencies 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
Creating Materialized Views → Why 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
1.9.2 Materialized Views → Materialized 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\"
Types of Materialized Views → FROM 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
6 Advanced Materialized Views → This 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
Rolling Materialized Views → be 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
7 Refreshing Materialized Views → This 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
About Nested Materialized Views → Materialized 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 materialized … views. This section contains the following topics: Why Use Nested Materialized