Optimize Query Performance

• Query Processing Overview
  • Query planning and dispatch
  • Query plans
  • Parallel query execution
• Query Performance Overview
  • Dynamic partition elimination
  • Memory optimization
• Use GPORCA Optimizer
  • GPORCA overview
  • GPORCA Features and Enhancements
  • GPORCA Optimizer Update Notes
• Update Statistics
  • Check whether statistics are up to date
  • Generate statistics selectively
  • 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 cases
  • Usage restrictions
  • Usage examples
  • Example of performance improvement