Summary

Completed

Database performance is determined by how execution plans work and how indexes are used. At the same time, you need to understand patterns and anti-patterns for relational databases and aim for good query choices and proper indexing. Query Store acts as a data recorder for the database engine, and it is focused on query performance and changes in execution plans.

Additional reading