Skip to content
S

sql-optimization-patterns

Optimizes SQL queries and indexes using EXPLAIN analysis

by wshobsonFree

Launch
#948in AI Skills
0In stores

Description

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to eliminate slow queries. Covers EXPLAIN plan analysis with key me…

Ratings & Reviews

No ratings yet

Be the first to rate sql-optimization-patterns.

People also visit

S

supabase-postgres-best-practices

Postgres performance rules: queries, connections, RLS, schema, locking

AI Skills
Launch
S

supabase agent-skills

Build correctly on Supabase: docs, security/RLS, tooling and schema management

AI Skills
Launch
D

dbt-agent-skills

Dbt workflows, project structure, model execution and tests

AI Skills
Launch
D

database-skills

Database design, queries and schema changes

AI Skills
Launch
D

duckdb-skills

Attach databases, run SQL and explore files with DuckDB

AI Skills
Launch
P

postgres (read-only SQL)

Safe read-only SQL queries against PostgreSQL

AI Skills
Launch

sql-optimization-patterns FAQ

What is sql-optimization-patterns?

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to eliminate slow queries. Covers EXPLAIN plan analysis with key metrics (Seq Scan, Index Scan, cost, rows, execution time) and five index types (B-Tree, Hash, GIN, GiST, BRIN) for different query patterns.

Is sql-optimization-patterns free?

Yes. sql-optimization-patterns is free to use.

Do I need to download sql-optimization-patterns?

No. sql-optimization-patterns runs in your browser at github.com, so there's nothing to install.

Who makes sql-optimization-patterns?

sql-optimization-patterns is made by wshobson.

What are the best sql-optimization-patterns alternatives?

Popular alternatives to sql-optimization-patterns include supabase-postgres-best-practices, supabase agent-skills and dbt-agent-skills. See all sql-optimization-patterns alternatives

Developer Stuff

Badges