query-optimization

query-optimization

SQL query optimization and performance tuning

1étoiles
0forks
Mis à jour 1/5/2026
SKILL.md
readonlyread-only
name
query-optimization
description

SQL query optimization and performance tuning

Query Optimization Skill

Overview

Optimize SQL queries for maximum performance across different database systems.

Topics Covered

Query Analysis

  • EXPLAIN plans
  • Execution statistics
  • Cost-based optimization
  • Query profiling
  • Wait event analysis

Indexing Strategy

  • B-tree indexes
  • Covering indexes
  • Partial indexes
  • Index selection
  • Index maintenance

Query Patterns

  • JOIN optimization
  • Subquery alternatives
  • Aggregate optimization
  • Pagination patterns
  • Bulk operations

Database Specific

  • PostgreSQL optimization
  • MySQL tuning
  • SQL Server hints
  • Oracle optimization
  • Cloud DB optimization

Prerequisites

  • SQL fundamentals
  • Database internals basics

Learning Outcomes

  • Analyze query plans
  • Create effective indexes
  • Rewrite slow queries
  • Tune database performance

You Might Also Like

Related Skills

zig-system-calls

zig-system-calls

87Kdev-database

Guides using bun.sys for system calls and file I/O in Zig. Use when implementing file operations instead of std.fs or std.posix.

oven-sh avataroven-sh
Obtenir
bun-file-io

bun-file-io

86Kdev-database

Use this when you are working on file operations like reading, writing, scanning, or deleting files. It summarizes the preferred file APIs and patterns used in this repo. It also notes when to use filesystem helpers for directories.

anomalyco avataranomalyco
Obtenir
vector-index-tuning

vector-index-tuning

26Kdev-database

Optimize vector index performance for latency, recall, and memory. Use when tuning HNSW parameters, selecting quantization strategies, or scaling vector search infrastructure.

wshobson avatarwshobson
Obtenir

Implement efficient similarity search with vector databases. Use when building semantic search, implementing nearest neighbor queries, or optimizing retrieval performance.

wshobson avatarwshobson
Obtenir

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

wshobson avatarwshobson
Obtenir
event-store-design

event-store-design

26Kdev-database

Design and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, choosing event store technologies, or implementing event persistence patterns.

wshobson avatarwshobson
Obtenir