Understanding indexes, query plans and performance in Azure SQL
Improving database performance is often a terrific way to have the desired application performance without having to build crazy-complex architectures. To have the performance you desire, you need to understand how the query you write is processed by the database engine, what is the generated execution plan (also sometimes referred to as DAG: Directed Acyclic Graph) and how to understand it. Then, what are indexes, what's the difference between the diverse types, and how they will affect the performance of your query is also vital to have not good, not great, but exceptional performances, on-prem and in the cloud. In this session we'll analyze all these concepts in a practical and developer-friendly way. Don’t miss it!
Microsoft, Principal Product Manager
Redmond, Washington, United States