List of Examples

• 4-1 Bitmap Index
• 4-2 Bitmap Index
• 4-3 Bitmap Join Index: One Dimension Table Columns Joins One Fact Table
• 4-4 Bitmap Join Index: Multiple Dimension Columns Join One Fact Table
• 4-5 Bitmap Join Index: Multiple Dimension Tables Join One Fact Table
• 4-6 Bitmap Join Index: Snowflake Schema
• 5-1 Creating a Materialized View (Total Number and Value of Sales)
• 5-2 Creating a Materialized View (Computed Sum of Sales)
• 5-3 Creating a Materialized View (Aggregates on a Single Table)
• 5-4 Materialized View Containing Only Joins
• 5-5 Nested Materialized View
• 5-6 Example 4: Creating a Materialized View
• 5-7 Example of Refreshing a Nested Materialized View
• 5-8 DBMS_MVIEW.EXPLAIN_MVIEW
• 6-1 Materialized View with Partition Key
• 6-2 Creating a Materialized View: Join Dependent Expression
• 6-3 Using Partition Markers in a Materialized View
• 6-4 Hierarchical Cube
• 6-5 Materialized View Using UNION ALL with Two Join Views
• 6-6 Materialized View Using UNION ALL with Joins and Aggregates
• 7-1 Verifying the PCT Status of a Materialized View
• 7-2 Verifying the PCT Status in a Materialized View's Detail Table
• 7-3 Verifying Which Partitions are Fresh
• 7-4 Verifying Which Subpartitions are Fresh
• 7-5 MERGE Operation
• 7-6 Omitting the INSERT Clause
• 7-7 Omitting the UPDATE Clause
• 7-8 Skipping the UPDATE Clause
• 7-9 Conditional Inserts with MERGE Statements
• 7-10 Using the DELETE Clause with MERGE Statements
• 7-11 Unconditional Inserts with MERGE Statements
• 8-1 Registering Tables
• 8-2 Registering Materialized Views
• 8-3 Unregister Materialized Views
• 8-4 Unregister Tables
• 8-5 Display the Objects Registered in a Group
• 8-6 Invoke Refresh Operations
• 8-7 Verify the Status of Objects Registered in a Group
• 8-8 Prepare Sync Refresh Groups
• 8-9 Execute Sync Refresh Groups
• 8-10 Registering a DROP Operation
• 8-11 Specifying Trusted DML Statements
• 8-12 Preparing Staging Logs
• 8-13 Filling in Missing Values for Deleting and Updating Records
• 8-14 Updating a Column to NULL
• 8-15 Displaying Staging Log Statistics
• 8-16 PREPARE_REFRESH Succeeds with Status COMPLETE
• 8-17 PREPARE_REFRESH Fails with Status ERROR_SOFT
• 8-18 Resume of PREPARE_REFRESH Succeeds
• 8-19 Abort of PREPARE_REFRESH
• 8-20 EXECUTE_REFRESH Completes Successfully
• 8-21 EXECUTE_REFRESH Succeeds Partially
• 8-22 Retrying a Refresh After a PARTIAL Status
• 8-23 Aborting a Refresh with a PARTIAL Status
• 8-24 Child Key Constraint Violation
• 11-1 Single Value Selection
• 11-2 Bounded Range Selection
• 11-3 Selection With Expression
• 11-4 Exact Match Selections
• 11-5 More Selection in the Query
• 11-6 No Rewrite Because of Fewer Selections in the Query
• 11-7 Multi-Column IN-List Selections
• 11-8 Selections Using IN-Lists
• 11-9 Multiple Selections or Expressions
• 11-10 View Constraints
• 11-11 Rewrite Using Equivalence
• 11-12 Rewrite Using Equivalence (UNION ALL)
• 11-13 Rewrite Using Equivalence (Using a Custom Aggregate)
• 11-14 Result Cache Materialized View
• 11-15 EXPLAIN_REWRITE Using REWRITE_TABLE
• 11-16 EXPLAIN_REWRITE Using a VARRAY
• 12-1 Creating a Table with Linear Ordering
• 12-2 Creating a Table with Linear Ordering and a Join
• 12-3 Creating a Table with Interleaved Ordering
• 12-4 Creating a Table with Interleaved Ordering and a Join
• 12-5 Redefining an Attribute-Clustered Table Online
• 13-1 Creating a Basic Zone Map Independent of Attribute Clustering
• 13-2 Creating a Join Zone Map Independent of Attribute Clustering
• 13-3 Making a Zone Map Unusable
• 13-4 Performing Complete Refresh for a Zone Map
• 13-5 Refreshing Zone Maps
• 13-6 Disabling Pruning for Zone Maps
• 13-7 Enabling Pruning for Zone Maps
• 13-8 Disabling Refresh for Zone Maps
• 13-9 Enabling Refresh on Commit for Zone Maps
• 13-10 Scan Pruning: Disabling Zone Maps with the NO_ZONEMAP Hint
• 13-11 Join Pruning: Disabling Zone Maps with the NO_ZONEMAP Hint
• 13-12 Partition Pruning: Disabling Zone Maps with the NO_ZONEMAP Hint
• 13-13 Enabling Zone Map Maintenance on Data Movement
• 13-14 Enabling Zone Map Maintenance on Direct Path Load
• 13-15 Enabling Zone Map Maintenance on both Data Movement and Load
• 13-16 Creating the my_sales Table
• 17-1 Merge Operation Using SQL
• 17-2 Unconditional Insert
• 17-3 Conditional ALL Insert
• 17-4 Conditional FIRST Insert
• 17-5 Mixed Conditional and Unconditional Insert
• 17-6 Table Functions Fundamentals
• 17-7 Pivoting
• 18-1 Ranking Order
• 18-2 Ranking On Multiple Expressions
• 18-3 RANK and DENSE_RANK
• 18-4 Per Group Ranking Example 1
• 18-5 Per Group Ranking Example 2
• 18-6 ROW_NUMBER
• 18-7 Cumulative Aggregate Function
• 18-8 Moving Aggregate Function
• 18-9 Centered Aggregate
• 18-10 Windowing Aggregate Functions with Logical Offsets
• 18-11 Windowing Aggregate Functions With Physical Offsets
• 18-12 Reporting Aggregate Example
• 18-13 RATIO_TO_REPORT
• 18-14 LAG/LEAD
• 18-15 LAG/LEAD Using IGNORE NULLS
• 18-16 FIRST_VALUE
• 18-17 NTH_VALUE
• 18-18 LISTAGG as Aggregate
• 18-19 LISTAGG as Reporting Aggregate
• 18-20 FIRST/LAST Example 1
• 18-21 FIRST/LAST Example 2
• 18-22 Hypothetical Rank and Distribution Example 1
• 18-23 Hypothetical Rank and Distribution Example 2
• 18-24 WIDTH_BUCKET
• 18-25 Linear Algebra
• 18-26 CASE
• 18-27 CASE for Aggregating Independent Subsets
• 18-28 Histogram Example 1
• 18-29 Histogram Example 2
• 19-1 Simple Cross-Tabular Report With Subtotals
• 19-2 ROLLUP
• 19-3 Partial ROLLUP
• 19-4 CUBE Keyword in a Query
• 19-5 Partial CUBE in a Query
• 19-6 GROUPING to Mask Columns
• 19-7 GROUPING For Readability
• 19-8 GROUPING Combined with HAVING
• 19-9 GROUP_ID in a Query
• 19-10 Composite Columns
• 19-11 Concatenated Groupings
• 19-12 Concatenated Groupings (Cross-Product of Two Grouping Sets)
• 19-13 Concatenated Groupings and Hierarchical Cubes
• 19-14 ROLLUP and CUBE Hierarchy Handling
• 19-15 WITH Clause
• 19-16 Concatenated ROLLUP
• 19-17 Hierarchical Cube Query
• 19-18 Complete Hierarchical Cube Materialized View
• 20-1 Pattern Match: Simple V-Shape with 1 Row Output per Match
• 20-2 Pattern Match for a Simple V-Shape with All Rows Output per Match
• 20-3 Pattern Match with an Aggregate on a Variable
• 20-4 Pattern Match for a W-Shape
• 20-5 Defining Union Row Pattern Variables
• 20-6 Defining Pattern Variables
• 20-7 RUNNING Versus FINAL Semantics
• 20-8 Periods of Increasing Prices
• 20-9 Price Dips of a Specified Magnitude
• 20-10 Prices Dips of Specified Magnitude When They Have Returned to the Original Price
• 20-11 Find both V and U Shapes in Trading History
• 20-12 Finding Elliott Wave Pattern: Multiple Instances of Inverted-V
• 20-13 Finding Elliott Waves and Specifying a Range of Acceptable Row Counts
• 20-14 Skipping into the Middle of a Match to Check for Overlapping Matches
• 20-15 Find Large Transactions Occurring Within a Specified Time Interval
• 20-16 Four or More Consecutive Identical Messages
• 20-17 Four or More Consecutive Authentication Failures
• 20-18 Authentication Failures from the Same IP Address
• 20-19 Simple Sessionization for Clickstream Data
• 20-20 Simple Sessionization with Aggregation
• 20-21 Sessionization for Phone Calls with Dropped Connections
• 20-22 Suspicious Money Transfer
• 21-1 Simple Query with the MODEL Clause