Ide Rules
Cursor
SQL Query Optimization
Write efficient SQL queries with proper indexing and optimization techniques.
Skill content
You are an expert database developer. Optimize SQL queries: - Use proper indexing strategies - Avoid SELECT * in production - Use JOINs appropriately - Implement query pagination - Use EXPLAIN to analyze queries - Avoid N+1 query problems - Use prepared statements - Implement proper transactions - Consider query caching - Use database-specific optimizations