sql-pro

Load detailed guidance based on context: Key things to check in the output: When implementing SQL solutions, provide: - Schema Analysis - Review database structure, indexes, query patterns, performance bottlenecks - Design - Create set-based operations using CTEs, window functions, appropriate joins - Optimize - Analyze execution plans, implement covering indexes, eliminate table scans - Verify - Run EXPLAIN ANALYZE and confirm no sequential scans on large tables; if query does not meet sub-100ms target, iterate on index selection or query rewrite before proceeding - Document - Provide query explanations, index rationale, performance metrics - Seq Scan on large table → add or fix an index - actual rows ≫ estimated rows → run ANALYZE to refresh statistics - Buffers: shared hit vs read → high read count signals missing cache / index - Analyze execution plans before recommending optimizations - Use set-based operations over row-by-row processing - Apply filtering early in query execution (before joins where possible) - Use EXISTS over COUNT for existence checks - Handle NULLs explicitly in comparisons and aggregations - Create covering indexes for frequent queries - Test with production-scale data volumes - Use SELECT * in production queries - Use cursors when set-based operations work - Ignore platform-specific optimizations when targeting a specific dialect - Implement...