Optimizes SQL Server database performance through expert index design, selection, and maintenance strategies.
T-SQL Index Strategies is a specialized Claude Code skill designed to help developers and DBAs architect high-performance SQL Server databases. It provides deep technical guidance on choosing between clustered and nonclustered indexes, implementing columnstore storage for data warehousing, and creating efficient covering indexes to eliminate key lookups. Whether you are dealing with query performance bottlenecks or planning a new schema, this skill offers the implementation patterns, composite key ordering logic, and maintenance scripts needed to ensure optimal data retrieval and storage efficiency.
Key Features
01Expert clustered and nonclustered index selection guidelines
02Columnstore optimization patterns for analytical workloads
037 GitHub stars
04Performance monitoring using DMVs and missing index statistics
05Index maintenance scripts for fragmentation management
06Composite key design and covering index implementation
Use Cases
01Architecting data warehouse storage using clustered columnstore indexes
02Automating database maintenance routines and statistic updates
03Resolving query performance bottlenecks through strategic index design
