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
In-Memory Aggregation: Example → sport bike USA WA 310 In-Memory Aggregation: Example In this example, the business question is \"How
In-Memory Aggregation → The 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
IM Aggregation: Scenario → This section gives a conceptual example of how VECTOR GROUP BY aggregation works. Note: The
AGGREGATION → Within 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.
Controls for In-Memory Aggregation → 1 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
Purpose of In-Memory Aggregation → database 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
Table 5-12 Aggregation Array → Step 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
How In-Memory Aggregation Works → join 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
1.7 In-Memory Aggregation → In-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
About Optimized Aggregation Performance → Not 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
Using In-Memory Aggregation → on 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
Using SQL Aggregation Management → SQL Aggregation Management is a group of PL/SQL subprograms in DBMS_CUBE that supports the rapid
About In-Memory Aggregation → In-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
aggregation → aggregation is synonymous with summarization, and aggregate data is synonymous with summary data.
Concatenated Groupings and Data Aggregation → Concatenated 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
Subprograms in SQL Aggregation Management → These subprograms are included in SQL Aggregation Management: CREATE_MVIEW Function
Example of SQL Aggregation Management → All 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.
Aggregation Operators → Figure 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
19 SQL for Aggregation in Data Warehouses → This 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
Considerations when Using Aggregation in Data Warehouses → Extensions Using Other Aggregate Functions with ROLLUP and CUBE Using In-Memory Aggregation