Performance optimization
- Partition pruning
- Optimize query performance
- General SQL optimization methods
- Slow query identification
- Statistics collection
- Execution plans
- Index optimization
- Sorting optimization (V6.0)
- Diagnose data bloat
- Diagnose data skew
- Slow query diagnostics
- Eliminate data redistribution
- Avoid spilling to disk
- Lock wait
- Reclaim space
- Configure regular vacuum tasks
- Use auto-vacuum
- Accelerate queries with MetaScan
- Use real-time materialized views to accelerate queries that contain variable parameters
- Configure parallel query
- Dynamic Join Filter
- Query Profiling Statistics
- Improve I/O throughput and IOPS
- Performance parameter tuning
- Rewrite recursive CTEs to improve query performance
- Query cache
- Troubleshoot and resolve compute skew