Optimize Query Performance

• Query Performance Overview
  • Dynamic partition elimination
  • Memory optimization
• Use GPORCA Optimizer
  • GPORCA Overview
  • GPORCA Features and Enhancements
  • What’s New in GPORCA Optimizer
• Update Statistics
  • Check whether statistics are updated
  • Selectively generate statistics
  • Improve statistics quality
  • When to run ANALYZE
  • Configure automatic statistics collection
• Query Hints
  • Quick example
  • Cardinality hints
  • Join type hints
  • Join order hints
  • Scope and limitations of hints
  • Best practices for query hints
• Automatically Use Materialized Views for Query Optimization
  • Scenarios
  • Example
  • How it works
  • Limitations
• Push Down Aggregation Operations
  • Usage example
  • Applicable scenarios
  • Scenarios where it is not recommended
  • Usage limitations
• Execute Queries in Parallel
  • Use cases
  • How to use
  • Parameter description
  • Frequently asked questions
• Auto-Clustering Tables
  • User value
  • How to use
  • How it works