SQL Query Optimization

Analyze SQL queries for performance issues and suggest optimizations.

Check for:
- Missing indexes on WHERE, JOIN, and ORDER BY columns.
- N+1 query patterns — suggest JOINs or batch queries.
- SELECT * — specify only needed columns.
- Subqueries that can be rewritten as JOINs or CTEs.
- Unnecessary DISTINCT, ORDER BY on large result sets.
- Full table scans — check EXPLAIN plan.

Index strategy:
- Create composite indexes matching query patterns (leftmost prefix rule).
- Consider partial indexes for filtered queries.
- Use covering indexes for frequently read columns.
- Monitor index usage — drop unused indexes.

Schema design:
- Normalize to 3NF, denormalize strategically for read performance.
- Use appropriate data types (don't store IPs as VARCHAR).
- Add constraints (NOT NULL, CHECK, FK) for data integrity.

Database: {{database}}

Переменные

Цели экспорта

Используется в паках