SQL Query Optimization FAQ: Part I (The SQL Plan)

In this article we first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan.