skills.rest
SukiEva
SukiEvaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

huawei-dws-sql-optimizer

Analyze raw SQL and EXPLAIN outputs to identify Huawei DWS slow SQL root causes.

Updated Jan 30, 2026
Search Tags:#query-tuning#execution-plan#huawei-dws#sql-optimizer#slow-sql-analysis#distributed-database#gaussdb
One-click install
npx skills add https://github.com/SukiEva/AgentSkills --skill huawei-dws-sql-optimizer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: huawei-dws-sql-optimizer
Source: https://github.com/SukiEva/AgentSkills/tree/main/skills/huawei-dws-sql-optimizer
Command: npx skills add https://github.com/SukiEva/AgentSkills --skill huawei-dws-sql-optimizer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

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.

Frequently Asked Questions about huawei-dws-sql-optimizer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow SQL queries in Huawei DWS?▼

Diagnosing slow SQL in Huawei DWS involves correlating raw queries with EXPLAIN and EXPLAIN PERFORMANCE outputs to expose root causes. You receive actionable optimization actions like CREATE INDEX suggestions, partition pruning fixes, and distribution-key redesign for distributed GaussDB environments.

What causes poor query performance in distributed GaussDB environments?▼

Poor query performance in distributed GaussDB environments often stems from data skew, inadequate distribution keys, or missing partition pruning. Analyzing execution plans reveals these root causes, enabling targeted rewrites and distribution changes to reduce skew and improve query speed.

How do I analyze EXPLAIN ANALYZE output for Huawei DWS execution plans?▼

Analyzing EXPLAIN ANALYZE output for Huawei DWS requires extracting plan signals and execution metrics to pinpoint bottlenecks. This evidence-driven assessment correlates metrics with raw SQL to generate a structured slow-SQL investigation report with verification steps.

Can I fix data skew issues in DWS by changing distribution keys?▼

Yes, you can fix data skew issues in DWS by redesigning distribution keys. Analyzing EXPLAIN outputs identifies distribution imbalances, allowing you to apply targeted skew reduction strategies and distribution-key modifications for optimized distributed query performance.

Does Huawei DWS SQL optimization require EXPLAIN PERFORMANCE outputs?▼

Huawei DWS SQL optimization heavily relies on EXPLAIN, EXPLAIN ANALYZE, and EXPLAIN PERFORMANCE outputs to perform evidence-driven root-cause analysis. Providing these plan outputs alongside raw SQL text generates a prioritized and validated optimization plan.

Related Skills

Explore More Data & Analytics Skills→
tonone-aitonone-ai
69

flux-query

Analyze SQL execution plans and generate index recommendations and rewritten queries.

Official
Intermediate
moveonhamoveonha
1

sql-optimizer

Detect PostgreSQL SQL anti-patterns and generate EXPLAIN ANALYZE-based optimization recommendations.

Community
Advanced
EmmraanEmmraan

database-performance

Diagnose and optimize PostgreSQL database performance issues across the lifecycle.

Community
Advanced
amber-moeamber-moe
9

oceanbase-sql-optimization

Provides SQL optimization for OceanBase databases including tuning, indexing, execution analysis, and slow-query mitigation across MySQL and Oracle modes.

Community
Advanced