Missing Indexes: Do's and Don'ts

# Missing Indexes: Do's and Don'ts

We've all written queries that have generated Missing Index Recommendations. Perhaps you've just implemented the recommendation and moved on with your day. Or maybe you've been told to not trust these recommendations at all. Should you use them or not? How do you navigate between these conflicting viewpoints?

Join me to learn how to properly interpret these recommendations. We'll explore the pros and cons of SQL Server's Missing Index Recommendations. And while these recommendations are generated for individual queries, you'll learn how to leverage their insights wisely to benefit your entire on-prem and/or Azure SQL workload.

Your queries will thank you!

## Andy Yun

#### Field Solutions Engineer

Andy Yun is a Field Solutions Architect at Pure Storage, who has been with SQL Server for over 20 years as both a Database Developer and Administrator. He focuses on performance tuning, with expertise in T-SQL, storage engine internals, and monitoring. Andy strongly believes in passing knowledge onto others, regularly speaking at conferences and user groups, and mentoring industry colleagues. Andy is a former Microsoft MVP, co-founder of the Chicago SQL Association, former co-leader of the Chicago Suburban User Group and Chicago SQL Saturday Organizing Committee.