查询加速 | StarRocks

📄️ 查看运行中的查询

如何在 StarRocks 中查看和监控运行中的查询、分析资源消耗并取消长时间运行的查询。

How to configure StarRocks CBO (Cost-based Optimizer) with statistics collection and histograms to optimize query execution plans.

How to use SQL Plan Manager in StarRocks to bind fixed query plans to SQL statements, preventing plan changes and stabilizing performance.

如何在 StarRocks 中使用查询反馈框架自动分析慢查询计划、通过查询计划顾问生成优化建议并改进查询性能。

How to create, use, and manage synchronous materialized views (Rollups) in StarRocks for transparent acceleration of single-table queries.

6 个项目

How to use Colocate Join in StarRocks to perform joins locally without network data transmission by co-locating joined table data.

How to use Lateral Join with unnest() in StarRocks to convert array columns to rows for ETL column-to-row transformations.

2 个项目

2 个项目

如何在 StarRocks 中使用有序流式聚合优化预排序数据的 GROUP BY 查询，降低内存开销。

如何在 StarRocks 中使用 AUTO INCREMENT 列和全局字典将字符串 Key 替换为整数 ID，加速精确去重和 Join 操作。

How to use Flat JSON in StarRocks to accelerate JSON queries by extracting common fields into flat columnar storage.

How to use table pruning to accelerate cardinality-preserving joins in StarRocks by removing redundant joined tables.

如何在 StarRocks 中启用和配置表达式的 JIT 即时编译以加速表达式求值和查询执行。

如何在 StarRocks 中通过 Skew Join V2 广播倾斜值优化存在数据倾斜的 JOIN 查询性能。