What platforms are supported by this skill?

This skill is specifically tailored for Microsoft SQL Server (all versions) and Azure SQL Database (Singleton, Elastic Pool, and Managed Instance).

How does this skill help with SARGability?

It identifies patterns like using functions on columns in WHERE clauses that prevent index seeks and suggests equivalent, index-friendly T-SQL syntax.

Can it help with SQL Server 2022 features?

Yes, it includes guidance on modern features like Parameter Sensitive Plan (PSP) optimization and Query Store hints for SQL Server 2022 and Azure SQL.

Can it identify missing indexes in my database?

Yes, it provides specific DMV-based queries to identify missing indexes with the highest potential impact on your system performance.

Does this skill provide solutions for Parameter Sniffing?

It provides multiple proven strategies including OPTION (RECOMPILE), local variables, and OPTIMIZE FOR hints to stabilize query performance.

T-SQL Query Optimization

Name: T-SQL Query Optimization
Author: JosiahSiegel

byJosiahSiegel

•

数据库管理

Optimizes SQL Server and Azure SQL Database performance through advanced T-SQL query tuning and execution plan analysis.

This skill empowers Claude to identify and resolve performance bottlenecks in T-SQL environments by applying industry-standard optimization techniques. It provides expert guidance on transforming non-SARGable patterns into index-friendly queries, resolving parameter sniffing issues, and interpreting complex execution plans. Whether you are working with legacy on-prem SQL Server or modern Azure SQL Databases, this skill helps you implement efficient joins, manage statistics, and leverage query hints to ensure high-performance data retrieval and minimal resource consumption.

主要功能

01Prevents performance degradation caused by implicit data type conversions

02Identifies and rewrites non-SARGable queries to enable efficient index seeks

03Resolves parameter sniffing issues using RECOMPILE, OPTIMIZE FOR, and PSP techniques

04Analyzes execution plans to detect costly operations like Table Scans and Key Lookups

057 GitHub stars

06Provides automated scripts for statistics management and missing index identification

使用场景

01Implementing covering index strategies to eliminate expensive bookmark lookups

02Diagnosing and fixing intermittent performance drops caused by unstable execution plans

03Refactoring slow-running legacy T-SQL queries to improve application response times

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add josiahsiegel/claude-plugin-marketplace query-optimization

For use in Claude.ai and ChatGPT

Download Skill