T-SQL query optimization techniques for SQL Server and Azure SQL Database. Use this skill when: (1) User needs to optimize slow queries, (2) User asks about SARGability or index seeks, (3) User needs help with query hints, (4) User has parameter sniffing issues, (5) User needs to understand execution plans, (6) User asks about statistics and cardinality estimation.
Quickly install query-optimization AI skill to your development environment via command line
Source: josiahsiegel/claude-plugin-marketplace.
| WHERE YEAR(Date) = 2024 | WHERE Date >= '2024-01-01' AND Date < '2025-01-01' | | WHERE LEFT(Name, 3) = 'ABC' | WHERE Name LIKE 'ABC%' | | WHERE Amount 1.1 > 1000 | WHERE Amount > 1000 / 1.1 | | WHERE ISNULL(Col, 0) = 5 | WHERE Col = 5 OR Col IS NULL | | WHERE VarcharCol = 123 | WHERE VarcharCol = '123' |
| Nested Loop | Small outer, indexed inner | Low memory, good for small sets | | Merge Join | Sorted inputs, similar sizes | Efficient for sorted data | | Hash Join | Large unsorted inputs | High memory, good for large sets |
| OPTION (RECOMPILE) | Fresh plan each execution | | OPTION (OPTIMIZE FOR (@p = value)) | Optimize for specific value | | OPTION (OPTIMIZE FOR UNKNOWN) | Use average statistics | | OPTION (MAXDOP n) | Limit parallelism | | OPTION (FORCE ORDER) | Use exact join order | | WITH (NOLOCK) | Read uncommitted (dirty reads) | | WITH (FORCESEEK) | Force index seek |
Stable fields and commands for AI/search citations.
npx skills add https://github.com/josiahsiegel/claude-plugin-marketplace --skill query-optimizationBrowse more skills from josiahsiegel/claude-plugin-marketplace
T-SQL query optimization techniques for SQL Server and Azure SQL Database. Use this skill when: (1) User needs to optimize slow queries, (2) User asks about SARGability or index seeks, (3) User needs help with query hints, (4) User has parameter sniffing issues, (5) User needs to understand execution plans, (6) User asks about statistics and cardinality estimation. Source: josiahsiegel/claude-plugin-marketplace.
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/josiahsiegel/claude-plugin-marketplace --skill query-optimization Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw
https://github.com/josiahsiegel/claude-plugin-marketplace