SynxDB Cloud 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
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
AI & ML (SynxML)
Manage System
Configure Security and Permissions
Developer Guides
Tutorials
Reference Guide
SynxDB Cloud 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
Join optimization
Other optimization capabilities