Elementary! The Curious Case of Deceptive Query Optimizer

We will see two important case studies where the optimizer is obviously a criminal who has killed the query performance. We will together with carefully investigate inside the query optimizer understand the reason.

Tags: Optimising,Monitoring,On-prem,Cloud,tuning,SQL 2019,Azure SQL Database,indexing,Database engine,optimizing