List of Figures

• 2-1 Views of Partitioned and Nonpartitioned Tables
• 2-2 List, Range, and Hash Partitioning
• 2-3 Composite Range—List Partitioning
• 2-4 Before Reference Partitioning
• 2-5 With Reference Partitioning
• 2-6 Local Partitioned Index
• 2-7 Global Partitioned Index
• 2-8 Global Nonpartitioned Index
• 3-1 Parallel Execution of a Full Partition-wise Join
• 3-2 Range and Hash Partitions of a Composite Table
• 3-3 Partial Partition-Wise Join
• 3-4 Local Prefixed Index
• 3-5 Local Nonprefixed Index
• 3-6 Global Prefixed Partitioned Index
• 5-1 Allocating Data Classes to a Partition
• 5-2 Data Usage Over Time
• 5-3 Data Lifecycle
• 8-1 Inter-operation Parallelism and Dynamic Partitioning
• 8-2 Data Flow Diagram for Joining Tables
• 8-3 Parallel Execution Server Connections and Buffers
• 8-4 Creating a Summary Table in Parallel
• 8-5 Unusable Free Space (Internal Fragmentation)
• 8-6 Asynchronous Read