This section provides information about fundamentals of join planning and a cross section of join optimizations. Not all optimizations are described. Use an EXPLAIN to see a summary of the optimizations done for your queries.
The information provided is designed to help you to interpret EXPLAIN reports more accurately, and provides some recommendations for how you can improved your plans. For more information about how to optimize the performance of your database from other perspectives, see Database Design.
- Optimizer Join Plans
- Join Geography
- Determining the Order of Joins
- Partial GROUP BY Block Optimization
- Join Strategies and Methods
- Product Join
- Merge Join
- Direct Row-partitioned PI Merge Join
- Rowkey-Based Merge Join
- Single-Window Merge Join
- Sliding-Window Merge Join
- Hash Join
- Nested Join
- Local Nested Join
- Slow Path Local Nested Join
- Fast Path Local Nested Join
- Remote Nested Join
- Nested Join Examples
- Join Plan without Nested Join
- Join Plan with Nested Join
- Exclusion Join
- Exclusion Merge Join
- Exclusion Product Join
- Inclusion Join
- Inclusion and Exclusion Product Joins with Dynamic Row Partition Elimination
- RowID Join
- Correlated Joins
- Self-Join