Inside the SQL Server Query Optimizer - part 1 Introduction and the input tree
Welcome back Guys! We are in 2020 and I would wish you a happy new year! I hope it will be a year of professional and personal growth for you. I hope it is a year of health, dedicated to affections and family! Today we start with the first article of this year and the second year of this blog that's growing fast! This first article of this year is about the Query Optimizer. I will present to you a series of articles in which we will go into detail on how the Query optimizer works. Enjoy the reading! Introduction We had already mentioned the subject in this article wich i really invite you to read here: SQL Server, the Parametrization and the Parameter Sniffing So let's review what we have already said: 1) The goal of the Query Optimizer is to find a good way to return data (aka find a good execution plan) that will be executed by the Query Executor. Remember : not the best plan. This is because in a non-trivial query there can be hundreds or thousand...