Optimize Performance

• Optimize Query Performance
  • Query Performance Overview
  • Use GPORCA Optimizer
  • Update Statistics
  • Query Hints
  • Automatically Use Materialized Views for Query Optimization
  • Push Down Aggregation Operations
  • Execute Queries in Parallel
  • Auto-Clustering Tables
  • TpServer Optimization Principles
• Use Dynamic Tables to Speed Up Queries and Auto-Refresh Data
  • Use cases
  • Usage
  • Examples
  • Notes