Uncategorized

Generally available: Query Store hints Azure SQL Database, Azure SQL Managed Instance

When you need to go beyond the Query Optimizer execution plan and manually optimize your queries for specific conditions, the Query Store hints feature provides an easy-to-use method for shaping query plans and behavior without changing the application code. Experiment within a tight loop by trying different hints and assessing the performance impact, all within SQL Server Management Studio (SSMS) or Azure Data Studio.

Learn more.