sql-optimization-patterns

name	sql-optimization-patterns
description	Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.
type	skill
created	2026-02-27T00:00:00.000Z
domain	software-development
category	database
risk	safe
source	community
tags	["skill","software-development","database","sql","optimization"]

SQL Optimization Patterns

Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.

Use this skill when

• Debugging slow-running queries
• Designing performant database schemas
• Optimizing application response times
• Reducing database load and costs
• Improving scalability for growing datasets
• Analyzing EXPLAIN query plans
• Implementing efficient indexes
• Resolving N+1 query problems

Do not use this skill when

• The task is unrelated to sql optimization patterns
• You need a different domain or tool outside this scope

Instructions

• Clarify goals, constraints, and required inputs.
• Apply relevant best practices and validate outcomes.
• Provide actionable steps and verification.
• If detailed examples are required, open resources/implementation-playbook.md.

Resources

• resources/implementation-playbook.md for detailed patterns and examples.

Connections

• Domain: [[Software Entwicklung]]
• Kategorie: [[Datenbanken]]
• Navigation: [[Skills Uebersicht]], [[Home]]