nw-query-optimization
CommunitySpeed up queries with expert optimization tactics
Software Engineering#indexing#sql#nosql#query-optimization#execution-plan#join-algorithms#cardinality-estimation
AuthorStudentCristian
Version1.0.0
Installs0
System Documentation
What problem does it solve?
SQL and NoSQL databases often run into performance bottlenecks due to suboptimal queries, missing indexes, or underperforming execution plans.
Core Features & Use Cases
- Cost-Based Optimization: Understand how optimizers choose plans using statistics and how stale data can degrade performance.
- Indexing Strategies: Guidance on B-Tree, Hash, covering indexes, compound indexes, and database-specific indexes.
- Execution Plan Analysis: Techniques to read and compare EXPLAIN outputs and identify bottlenecks.
- Join Algorithm Guidance: Rules of thumb for Nested Loop, Hash Join, and Merge Join based on data and indexes.
- Cardinality Estimation: Approaches using histograms and density vectors, plus stat maintenance.
Quick Start
Analyze a slow query plan and propose an indexing change to improve performance.
Dependency Matrix
Required Modules
None requiredComponents
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: nw-query-optimization Download link: https://github.com/StudentCristian/nWave-github/archive/main.zip#nw-query-optimization 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.