Optimize Performance

• Optimize Query Performance
  • Query Processing Overview
  • Query Performance Overview
  • Use GPORCA Optimizer
  • Update Statistics
  • Query Plan Hints
  • Use Unique Indexes on AO Tables
  • Use Automatic Materialized Views for Query Optimization
  • Use Incremental Materialized Views
  • Execute Queries in Parallel
  • Use Index Scan on AO Tables
  • Push Down Aggregation Operations
  • Optimize HashJoin Query Performance
• Create Indexes Concurrently
  • CREATE INDEX CONCURRENTLY
  • REINDEX CONCURRENTLY
• Create AO/AOCO Tables in Parallel and Refresh Materialized Views
  • Usage examples
  • Performance improvement demonstration
• Manage Resources Using Resource Groups
  • Role and component resource groups
  • Resource group attributes and limits
  • Configure and use resource groups
  • Enable resource groups
  • Create resource groups
  • Configure automatic query termination based on memory usage
  • Assign a resource group to a role
  • Monitor resource group status
  • Move a query to a different resource group
  • Frequently asked questions
• Use Dynamic Tables to Speed Up Queries and Auto-Refresh Data
  • Use cases
  • Comparison with materialized views
  • Usage
  • Examples
  • Notes