AI SQL Tuner Studio 1.0.28 — Introducing Query Tuner
AI SQL Tuner Studio 1.0.28 is now available, and it introduces a significant new capability: Query Tuner . This release also rolls up Index Tuning improvements that shipped in 1.0.27 but were never formally announced. Query Tuner: AI-Powered Execution Plan Analysis Query Tuner is a new tuning goal that analyzes a single SQL query in depth. Point it at any stored procedure, ad-hoc query, or batch, and it captures the estimated execution plan via SET SHOWPLAN_XML ON , then parses the plan XML to identify referenced tables, operators, warnings, and missing index hints. From there it collects targeted metadata — index usage stats, DMV missing indexes, table sizes, foreign keys, column cardinality, and statistics settings — scoped only to the tables your query actually touches. Everything is sent to the AI model, which returns prioritized, evidence-based recommendations specific to that query. What You Get in the Report The Query Tuner report is structured around actionable secti...