List of Examples

6-1 Bitmap Index

6-2 Bitmap Index

6-3 Bitmap Join Index: One Dimension Table Columns Joins One Fact Table

6-4 Bitmap Join Index: Multiple Dimension Columns Join One Fact Table

6-5 Bitmap Join Index: Multiple Dimension Tables Join One Fact Table

6-6 Bitmap Join Index: Snowflake Schema

8-1 Example 1: Creating a Materialized View

8-2 Example 2: Creating a Materialized View

8-3 Example 3: Creating a Materialized View

8-4 Materialized View Containing Only Joins

8-5 Nested Materialized View

8-6 Creating a Materialized View

8-7 Example of Refreshing a Nested Materialized View

8-8 DBMS_MVIEW.EXPLAIN_MVIEW

9-1 Partition Key

9-2 Join Dependent Expression

9-3 Partition Marker

9-4 Hierarchical Cube

9-5 Materialized View Using UNION ALL with Two Join Views

9-6 Materialized View Using UNION ALL with Joins and Aggregates

14-1 Merge Operation Using SQL

14-2 Unconditional Insert

14-3 Conditional ALL Insert

14-4 Conditional FIRST Insert

14-5 Mixed Conditional and Unconditional Insert

14-6 Table Functions Fundamentals

14-7 Pivoting

15-1 MERGE Operation

15-2 Omitting the INSERT Clause

15-3 Omitting the UPDATE Clause

15-4 Skipping the UPDATE Clause

15-5 Conditional Inserts with MERGE Statements

15-6 Using the DELETE Clause with MERGE Statements

15-7 Unconditional Inserts with MERGE Statements

16-1 Obtaining the Oracle Streams Capture Parallelism Value

16-2 Obtaining the Oracle Streams Apply Parallelism Value

16-3 Sample TARGET_COLMAP$ VALUE

17-1 Creating a Workload

17-2 Creating a Workload from a Template

17-3 Optimizing the Defining Query for Fast Refresh

17-4 Access IMPLEMENTATION Output Through USER_TUNE_MVIEW View

17-5 Save IMPLEMENTATION Output in a Script File

17-6 Enable Query Rewrite by Creating Multiple Materialized Views

17-7 Access IMPLEMENTATION Output Through USER_TUNE_MVIEW View

17-8 Save IMPLEMENTATION Output in a Script File

17-9 Optimized Sub-Materialized View for Fast Refresh

17-10 Access IMPLEMENTATION Output Through USER_TUNE_MVIEW View

17-11 Save IMPLEMENTATION Output in a Script File

18-1 Single Value Selection

18-2 Bounded Range Selection

18-3 Selection With Expression

18-4 Exact Match Selections

18-5 More Selection in the Query

18-6 No Rewrite Because of Fewer Selections in the Query

18-7 Multi-Column IN-List Selections

18-8 Selections Using IN-Lists

18-9 Multiple Selections and Disjuncts

18-10 View Constraints

18-11 EXPLAIN_REWRITE Using REWRITE_TABLE

18-12 EXPLAIN_REWRITE Using a VARRAY

18-13 Rewrite Using Equivalence

18-14 Rewrite Using Equivalence (UNION ALL)

18-15 Rewrite Using Equivalence (Using a Custom Aggregate)

20-1 Simple Cross-Tabular Report With Subtotals

20-6 GROUPING to Mask Columns

20-7 GROUPING For Readability

20-8 GROUPING Combined with HAVING

20-9 GROUP_ID

20-10 Composite Columns

20-11 Concatenated Groupings

20-12 Concatenated Groupings (Cross-Product of Two Grouping Sets)

20-13 Concatenated Groupings and Hierarchical Cubes

20-14 ROLLUP and CUBE Hierarchy Handling

20-15 WITH Clause

20-16 Concatenated ROLLUP

20-17 Hierarchical Cube Query

20-18 Complete Hierarchical Cube Materialized View

21-1 Ranking Order

21-2 Ranking On Multiple Expressions

21-3 RANK and DENSE_RANK

21-4 Per Group Ranking Example 1

21-5 Per Group Ranking Example 2

21-6 ROW_NUMBER

21-7 Cumulative Aggregate Function

21-8 Moving Aggregate Function

21-9 Centered Aggregate

21-10 Windowing Aggregate Functions with Logical Offsets

21-11 Windowing Aggregate Functions With Physical Offsets

21-12 Reporting Aggregate Example

21-13 RATIO_TO_REPORT

21-14 LAG/LEAD

21-15 FIRST/LAST Example 1

21-16 FIRST/LAST Example 2

21-17 Hypothetical Rank and Distribution Example 1

21-18 Hypothetical Rank and Distribution Example 2

21-19 WIDTH_BUCKET

21-20 CASE

21-21 Histogram Example 1

21-22 Histogram Example 2

22-1 Simple Query with the MODEL Clause

24-1 Distributed Transaction Parallelization

24-2 Distributed Transaction Parallelization

24-3 Distributed Transaction Parallelization

24-4 Parallelization: Example 1

24-5 Parallelization: Example 2

24-6 Parallelization: Example 3

24-7 Parallelizing INSERT ... SELECT

24-8 Parallelizing UPDATE and DELETE

24-9 Parallelizing UPDATE and DELETE