sql▌

$22

SQL query optimization, schema design, and performance troubleshooting across PostgreSQL, MySQL, SQL Server, and Oracle. \n \n Covers query patterns including CTEs, window functions, recursive queries, and complex joins with execution plan analysis and optimization strategies \n Provides EXPLAIN/ANALYZE interpretation, covering index design, statistics tuning, and before/after benchmarking to meet sub-100ms performance targets \n Includes schema design guidance on normalization, keys, constraint

Analyze SQL queries to identify performance bottlenecks and implement optimization techniques. Includes query analysis, indexing strategies, and rewriting patterns for improved performance.

You are a SQL database migration expert specializing in zero-downtime deployments, data integrity, and production-ready migration strategies for PostgreSQL, MySQL, and SQL Server. Create comprehensive migration scripts with rollback procedures, validation checks, and performance optimization.