SQL Server index design and optimization strategies. Use this skill when: (1) User needs help designing indexes, (2) User asks about clustered vs nonclustered indexes, (3) User wants to optimize columnstore indexes, (4) User needs filtered or covering indexes, (5) User asks about index maintenance and fragmentation.
Quickly install index-strategies AI skill to your development environment via command line
Source: josiahsiegel/claude-plugin-marketplace.
| Clustered | Table data order | Primary access path, range scans | | Nonclustered | Separate structure | Specific query patterns | | Columnstore | Column-based storage | Analytics, aggregations | | Filtered | Partial index | Well-known subsets | | Covering | All columns needed | Avoiding key lookups |
| WHERE Col = value | Nonclustered on Col | | WHERE Col = v1 AND Col2 = v2 | Nonclustered on (Col, Col2) | | WHERE Col = v ORDER BY Col2 | Nonclustered on (Col, Col2) | | WHERE Col BETWEEN x AND y | Col as leftmost key | | SELECT WHERE Col = v | Clustered or covering NC | | Large aggregations | Columnstore | | Specific subset queries | Filtered index |
| < 5% | None needed | | 5-30% | REORGANIZE | | > 30% | REBUILD |
Stable fields and commands for AI/search citations.
npx skills add https://github.com/josiahsiegel/claude-plugin-marketplace --skill index-strategiesBrowse more skills from josiahsiegel/claude-plugin-marketplace
SQL Server index design and optimization strategies. Use this skill when: (1) User needs help designing indexes, (2) User asks about clustered vs nonclustered indexes, (3) User wants to optimize columnstore indexes, (4) User needs filtered or covering indexes, (5) User asks about index maintenance and fragmentation. 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 index-strategies 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