Skills
.Work. You
Rest

starrocks-query-optimizer

Community

Make StarRocks queries faster and cheaper

Data & Analytics#query optimization#starrocks#predicate pushdown#runtime filters#join strategy#cbo statistics#pipeline tuning
Authorivanshamaev
Version1.0.0
Installs0

System Documentation

What problem does it solve?

StarRocks query performance problems caused by inefficient execution plans, missing statistics, ineffective predicate pushdown, or absent runtime filters.

Core Features & Use Cases

  • Vectorized execution and pipeline tuning: Helps you reason about StarRocks’ column batch processing and pipeline model to select better parallelism (pipeline DOP) and reduce operator overhead.
  • Runtime filters, predicate pushdown, and partition pruning: Diagnoses why scans aren’t skipping data (e.g., RF missing or not applied, predicates not pushed down, partitions/tablets not pruned).
  • CBO statistics and optimizer control: Guides collecting/updating CBO stats (ANALYZE TABLE, histograms, auto-analyze) and using session variables or hints to override suboptimal optimizer decisions (join strategy, join order, caching behavior).

Quick Start

Load this skill and tell the user to run EXPLAIN VERBOSE for their StarRocks SQL to identify missing runtime filters, lack of partition pruning, and suboptimal join strategy.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: starrocks-query-optimizer
Download link: https://github.com/ivanshamaev/de-agent-skills/archive/main.zip#starrocks-query-optimizer

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.