List of Tables

• 4-1 Sample Bitmap Index
• 4-2 Sample Bitmap Join Index
• 5-1 Requirements for Materialized Views with Aggregates
• 5-2 Build Methods
• 5-3 Refresh Modes
• 5-4 Refresh Options
• 5-5 Constraints
• 5-6 CAPABILITY_NAME Column Details
• 5-7 MV_CAPABILITIES_TABLE Column Details
• 6-1 ROLLUP By Time and Product
• 7-1 ON DEMAND Refresh Methods
• 8-1 CAN_SYNCREF_TABLE
• 11-1 Dimension and Constraint Requirements for Query Rewrite
• 11-2 Partition Names and Their Pmarkers
• 11-3 View Constraints and Rewrite Integrity Modes
• 13-1 Data Blocks for lineitem Table
• 13-2 Zone Map for lineitem Table
• 18-1 Analytic Functions and Their Uses 
• 18-2 Common Diagnostic Statistics and Their Expressions 
• 19-1 Simple Cross-Tabular Report With Subtotals
• 19-2 GROUPING_ID Example for CUBE(a, b)
• 19-3 GROUPING SETS Statements and Equivalent GROUP BY
• 19-4 Hierarchical CUBE Example
• 20-1 Pattern and Row
• 20-2 Pattern and Partitioned Data
• 20-3 Row Pattern Navigation
• 20-4 Pattern and Row
• 20-5 Pattern and Row
• 20-6 Data Set and Mappings
• 21-1 Ordered Rules