Optimize Query Performance

• Query Processing Overview
  • Query planning and dispatch
  • Query plans
  • Parallel query execution
  • Interpret the EXPLAIN ANALYZE output for hash aggregation
• Query Performance Overview
  • Dynamic partition elimination
  • Memory optimization
  • Numeric aggregation optimization
• Use GPORCA Optimizer
  • GPORCA overview
  • GPORCA Features and Enhancements
  • GPORCA Performance Tuning
• Update Statistics
  • Checking whether statistics are up to date
  • Generate statistics selectively
  • Skip unmodified relations
  • Improve statistics quality
  • When to run ANALYZE
  • Configure automatic statistics collection
• Query Plan Hints
  • Quick example
  • Cardinality hints
  • Table access hints
  • Join type hints
  • Join order hints
  • Supported scope and limitations
  • Best practices for using query plan hints
• Use Unique Indexes on AO Tables
  • How it works
  • How to add a unique index to an AO table
  • Usage examples
• Use Automatic Materialized Views for Query Optimization
  • Usage scenarios
  • Implementation
  • Comparison with dynamic tables
  • Restrictions
  • Usage examples
  • Use materialized views to query external tables
  • Aggregate query support
• Use Incremental Materialized Views
  • Use cases
  • Usage example
  • Query performance comparison with regular views
  • Usage restrictions and notes
• Execute Queries in Parallel
  • Use cases
  • How to use
  • Parameter descriptions
  • Frequently asked questions
• Use Index Scan on AO Tables
  • Use cases
  • Usage example
• Push Down Aggregation Operations
  • Usage example
  • Use cases
  • Not recommended scenarios
  • Usage restrictions
• Optimize HashJoin Query Performance
  • Use RuntimeFilter in the Postgres optimizer
  • Push down filters to dynamic scans in GPORCA
  • Push down runtime filters to Table Access Method (AM)
• Just-in-Time Compilation (JIT)
  • What is JIT compilation
  • User scenarios
  • Principles of JIT compilation
  • How to use JIT compilation
  • Notes and limitations
  • Related reference information