SynxDB Elastic Documentation
Table of Contents
Product Overview
Deployment
Load Data
Operate with Data
Optimize Performance
Optimize Query Performance
Query Performance Overview
Use GPORCA Optimizer
GPORCA Overview
GPORCA Features and Enhancements
What’s New in GPORCA Optimizer
Update Statistics
Query Hints
Automatically Use Materialized Views for Query Optimization
Push Down Aggregation Operations
Execute Queries in Parallel
Auto-Clustering Tables
Manage System
Configure Security and Permissions
Developer Guides
Tutorials
Reference Guide
SynxDB Elastic Documentation
Optimize Performance
Optimize Query Performance
Use GPORCA Optimizer
Use GPORCA Optimizer
GPORCA Overview
Enable or disable GPORCA
Determine which query optimizer is used
GPORCA Features and Enhancements
Enhancements for partitioned table queries
Subquery optimization
Common Table Expression (CTE) optimization
DML operation optimization
Other optimization capabilities
What’s New in GPORCA Optimizer
v4.0