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 aggregation


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


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

Query Transformations

In-Memory Aggregation: Examplesport bike USA WA 310 In-Memory Aggregation: Example In this example, the business question is \"How

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

Query Transformations

In-Memory AggregationThe basic approach of in-memory aggregation is to aggregate while scanning. To optimize query … blocks involving aggregation and joins from a single large table to multiple small tables, such as in a … operations use efficient in-memory arrays for joins and aggregation, and are especially effective when the … of In-Memory Aggregation

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

Query Transformations

IM Aggregation: ScenarioThis section gives a conceptual example of how VECTOR GROUP BY aggregation works. Note: The

OLAP DML Reference, 12c Release 1 (12.1)

OLAP DML Functions: A - K

AGGREGATIONWithin a model, the AGGREGATION function allows you to create a model that represents a custom … aggregate. Such an aggmap can be used for dynamic aggregation with the AGGREGATE function.

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

Query Transformations

Controls for In-Memory Aggregation1 1 1 0 0 0 Two Phases of IM Aggregation Typically, VECTOR GROUP BY aggregation processes each … dimension in sequence, and then processes the fact table. When performing IM aggregation, the database … Aggregation Description of \"Figure 5-2 Phase 1 of In-Memory Aggregation\" Process the fact table

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

Query Transformations

Purpose of In-Memory Aggregationdatabase accelerates the work up to and including the first aggregation, which is where the SQL engine must … process the largest volume of rows. Vector joins and group-by operations (or aggregation) can occur

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

Query Transformations

Table 5-12 Aggregation ArrayStep 5: Aggregation Using an Array The database uses a multidimensional array to perform the … aggregation. In Table 5-12, the geography grouping keys are horizontal, and the products grouping keys are … , the sum of 110 and 200 is 310. Table 5-12 Aggregation Array dgkp/dgkg 1 2 1 110,200   2   130 3   120 4 100  

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

Query Transformations

How In-Memory Aggregation Worksjoin keys have low cardinality. VECTOR GROUP BY aggregation spends extra time processing the small … data flow operator (DFO). VECTOR GROUP BY aggregation uses a DFO for each dimension to create a key

Database New Features Guide, 12c Release 1 (12.1)

Oracle Database 12c Release 1 (12.1.0.2) New Features

1.7 In-Memory AggregationIn-Memory Aggregation optimizes queries that join dimension tables to fact tables and aggregate … aggregation operations. These operations may be automatically chosen by the SQL optimizer based on cost … estimates. In-Memory Aggregation improves performance of star queries and reduces CPU usage, providing … . In-Memory Aggregation

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

SQL for Aggregation in Data Warehouses

About Optimized Aggregation PerformanceNot only multidimensional issues, but all types of processing can benefit from enhanced aggregation … details to higher levels will benefit from optimized aggregation performance. These extensions … provide aggregation features and bring many benefits, including: Simplified programming requiring less SQL … and network traffic

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

SQL for Aggregation in Data Warehouses

Using In-Memory Aggregationon data. In-memory aggregation uses KEY VECTOR and VECTOR GROUP BY operations to optimize query … blocks involving aggregation and joins from a single large table to multiple small tables, such as in a … typical star query. These operations use efficient in-memory arrays for joins and aggregation, and … efficient in-memory array-based

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_CUBE

Using SQL Aggregation ManagementSQL Aggregation Management is a group of PL/SQL subprograms in DBMS_CUBE that supports the rapid

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

Data Warehousing Logical Design

About In-Memory AggregationIn-memory aggregation uses the VECTOR GROUP BY operation to enhance the performance of queries that … aggregation works VECTOR GROUP BY aggregation will only by chosen for GROUP BY. It will not be … -memory aggregation: VECTOR GROUP BY Aggregation and the Oracle In-Memory Column Store When to Use

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

Glossary

aggregationaggregation is synonymous with summarization, and aggregate data is synonymous with summary data.

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

SQL for Aggregation in Data Warehouses

Concatenated Groupings and Data AggregationConcatenated groupings offer a concise way to generate useful combinations of groupings. Groupings specified with concatenated groupings yield the cross-product of groupings from each grouping set. The cross-product operation enables even a small number of concatenated groupings to generate a large number of final groups. The concatenated groupings are specified simply by listing multiple grouping

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_CUBE

Subprograms in SQL Aggregation ManagementThese subprograms are included in SQL Aggregation Management: CREATE_MVIEW Function

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_CUBE

Example of SQL Aggregation ManagementAll examples for the SQL Aggregate Management subprograms use the sample Sales History schema, which is installed in Oracle Database with two relational materialized views: CAL_MONTH_SALES_MV and FWEEK_PSCAT_SALES_MV.

OLAP User's Guide, 12c Release 1 (12.1)

Advanced Aggregations

Aggregation OperatorsFigure 9-1 Summary Aggregation in a Simple Hierarchy Description of \"Figure 9-1 Summary … Aggregation in a Simple Hierarchy\" The Average operator calculates the average of all real data, producing an … aggregate value of ((2 + 4 + 6)/3)=4, as shown in Figure 9-2. Figure 9-2 Average Aggregation in a … Simple Hierarchy Description

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

SQL for Aggregation in Data Warehouses

19 SQL for Aggregation in Data WarehousesThis chapter discusses aggregation of SQL, a basic aspect of data warehousing. It contains these … topics: Overview of SQL for Aggregation in Data Warehouses ROLLUP Extension to GROUP BY CUBE Extension … Concatenated Groupings and Data Aggregation Considerations when Using Aggregation in Data Warehouses

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

SQL for Aggregation in Data Warehouses

Considerations when Using Aggregation in Data WarehousesExtensions Using Other Aggregate Functions with ROLLUP and CUBE Using In-Memory Aggregation