SQL: Rewrite a Slow Query for 10x Performance
Optimise a slow query with a step-by-step EXPLAIN ANALYZE walkthrough.
AI prompts for SQL optimization, database design, data analysis, ETL pipelines, and business intelligence reporting.
15 prompts found
Optimise a slow query with a step-by-step EXPLAIN ANALYZE walkthrough.
Produce a normalised schema, migrations, and seed data for a new product feature.
Audit a query log for N+1 issues and produce a fix with ORM-specific eager loading.
Plan a schema migration that runs safely against a live production database.
Generate a complete set of KPI queries for a common business dashboard.
Design a normalized database schema from business requirements — tables, relationships, indexes, constraints,...
Optimize slow SQL queries step by step — EXPLAIN analysis, index strategies, query rewriting, and caching for...
Design a complete database backup and recovery strategy — automated backups, point-in-time recovery, cross-reg...
Optimize slow SQL queries — analyze execution plans, add missing indexes, rewrite subqueries, and benchmark be...
Design a complete ETL/ELT data pipeline — from source extraction to transformation logic, loading strategy, an...
Design a data dashboard with the right chart types, layout hierarchy, KPI placement, and interactive filters —...
Plan a zero-downtime database migration — from schema changes and data migration to rollback strategy, testing...