sql-optimization-patterns

To analyze an EXPLAIN plan for slow SQL queries, you review the execution plan output to identify bottlenecks like sequential scans or inefficient joins. This Skill provides guidance on reading query plans to pinpoint missing indexes and resolve slow-running queries.

The best way to optimize SQL pagination is by applying specific query optimization patterns that avoid deep offset scans. This Skill details techniques for efficient pagination and aggregation to enhance database performance on large datasets.

To eliminate N+1 queries, you apply specific query optimization patterns that consolidate multiple individual queries into batch operations. This Skill covers these patterns to resolve slow queries and improve application throughput.

Choosing the right index type for PostgreSQL or MySQL depends on your query needs, utilizing structures like B-Tree, Hash, or GIN. This Skill explains indexing strategies to create effective indexes for various database workloads.

You should use materialized views and partitioning for query tuning when dealing with complex aggregations or massive tables that cannot be optimized with indexes alone. This Skill includes these advanced techniques to enhance database performance.