huawei-dws-sql-optimizer
CommunityDiagnose Huawei DWS slow SQL with actionable tips
Data & Analytics#query-tuning#execution-plan#huawei-dws#sql-optimizer#slow-sql-analysis#distributed-database#gaussdb
AuthorSukiEva
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Analyze Huawei DWS slow SQL by correlating raw SQL with EXPLAIN/EXPLAIN ANALYZE/EXPLAIN PERFORMANCE outputs to reveal root causes and practical optimization actions for DWS, including indexing, distribution changes, and safe SQL rewrites.
Core Features & Use Cases
- End-to-end root-cause analysis for Huawei DWS slow SQL using evidence-driven assessment of plans and execution metrics.
- Actionable optimization guidance, including CREATE INDEX suggestions, analyze/statistics checks, partition pruning fixes, distribution-key redesign, and skew reduction strategies.
- Structured slow-SQL investigation reports with recommended SQL, verification steps, risks, and a ready-to-run plan.
Quick Start
Provide the raw SQL and plan outputs to generate a prioritized, evidence-based optimization plan for Huawei DWS.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferencesassets
💻 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: huawei-dws-sql-optimizer Download link: https://github.com/SukiEva/AgentSkills/archive/main.zip#huawei-dws-sql-optimizer Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.