Optimizing SQL Queries

Optimize slow analytical SQL by reading query/EXPLAIN plans, cutting scanned data, fixing join strategy, and using partitioning, clustering, and indexes across Postgres, Snowflake, BigQuery, Databricks/Spark SQL, and Redshift. Use when a query is slow, times out, costs too much, scans too many rows/bytes, or spills to disk.

Unknown-333 Updated 26 repo stars
Awesome Data Engineering Skills — data-engineering skills for your AI coding agent

File contents

Unknown-333/awesome-data-engineering-skills commit 8901e2bfa9

Frequently asked questions

npx get-skill add unknown-333/optimizing-sql-queries