SQL Plan Management — 2 Technical Articles

Apr 24, 2025 · Databases

Inside StarRocks Optimizer: Architecture, Multi‑Stage Optimization, and Advanced Features

This article provides a comprehensive technical overview of StarRocks' query optimizer, covering its evolution, core architecture, multi‑stage optimization pipeline, key optimizations such as multi‑join colocate, low‑cardinality global dictionary, MV union rewrite, and advanced mechanisms like cost‑estimation fixes, query feedback, adaptive execution, runtime filters, join‑reorder strategies, and SQL plan management.

Adaptive ExecutionMaterialized ViewsOLAP

0 likes · 26 min read

Inside StarRocks Optimizer: Architecture, Multi‑Stage Optimization, and Advanced Features

ITPUB

Dec 19, 2019 · Databases

Step-by-Step Oracle 19c Upgrade: Performance Comparison, SPA, and AutoUpgrade

This guide walks through upgrading an Oracle database to 19c, comparing pre‑ and post‑upgrade performance with HammerDB and AWR snapshots, using SQL Performance Analyzer and SQL Plan Management to evaluate SQL tuning sets, applying SQL Tuning Advisor recommendations, and finally automating the upgrade with the AutoUpgrade tool and post‑upgrade compatibility adjustments.

AutoUpgradeDatabase UpgradeHammerDB

0 likes · 11 min read

Step-by-Step Oracle 19c Upgrade: Performance Comparison, SPA, and AutoUpgrade