{"skill":{"slug":"sql-optimization-patterns","displayName":"Sql Optimization Patterns","summary":"Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when de...","tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":196,"installsAllTime":1,"installsCurrent":1,"stars":0,"versions":1},"createdAt":1774246449236,"updatedAt":1774247215229},"latestVersion":{"version":"1.0.0","createdAt":1774246449236,"changelog":"Initial release: Master SQL query optimization with practical patterns, indexing, and EXPLAIN analysis.\n\n- Covers when and how to use query optimization techniques for performance.\n- Explains reading EXPLAIN plans, key metrics, and join strategies.\n- Details best index types and indexing patterns for common scenarios.\n- Provides query rewrite examples for N+1 issues, efficient pagination, and fast aggregates.\n- Outlines optimization patterns for subqueries and batch operations.\n- Suitable for debugging slow queries, schema design, and scaling applications.","license":"MIT-0"},"metadata":null,"owner":{"handle":"watermelon11","userId":"s17df19wxjdtv8p1000n1vgbv983kwnd","displayName":"nacy","image":"https://avatars.githubusercontent.com/u/28687015?v=4"},"moderation":null}