Skills
.Work. You
Rest

index-strategies

Community

Optimize SQL Server index design.

Software Engineering#indexing#database#optimization#performance tuning#sql server#tsql
AuthorJosiahSiegel
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps users design and optimize SQL Server indexes to improve database query performance and efficiency.

Core Features & Use Cases

  • Index Type Guidance: Explains clustered, nonclustered, columnstore, filtered, and covering indexes.
  • Design Best Practices: Provides recommendations for choosing index keys, column order, and specific index types based on query patterns.
  • Maintenance Strategies: Details how to manage index fragmentation and update statistics.
  • Performance Monitoring: Shows how to identify missing index opportunities and analyze index usage.

Quick Start

Use the index-strategies skill to get recommendations for optimizing the 'Orders' table indexes.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: index-strategies
Download link: https://github.com/JosiahSiegel/claude-plugin-marketplace/archive/main.zip#index-strategies

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.