Query Optimization
The Query Engine provides multiple optimization mechanisms to reduce query latency, minimize resource consumption, and improve overall platform efficiency. This section covers cost estimation, materialized views, workload management, saved queries, and query scheduling.
Optimization Capabilities
| Capability | Controller | Description |
|---|---|---|
| Cost estimation | CostEstimationController | Pre-execution cost prediction and engine comparison |
| Materialized views | MaterializedViewController | Pre-computed query results for acceleration |
| Workload management | WorkloadController | Queue management, resource pools, quota enforcement |
| Saved queries | SavedQueryController | Reusable query library with sharing |
| Query scheduling | QueryScheduleController | Automated recurring query execution |
Subsections
| Page | Description |
|---|---|
| Cost Estimation | Query cost prediction, engine comparison, threshold checks |
| Materialized Views | View creation, refresh, matching, suggestions |
| Workload Management | Queue management, resource pools, tenant quotas, throttling |
| Saved Queries | Query library, sharing, tagging, popularity |
| Query Scheduling | Cron schedules, interval execution, pause/resume, execution history |