"Understanding execution plans" will walk you through steps how SQL Server breaks down query in order to access or modify the data in the database. With execution plan you can understand the statements that exists within the query. Showing execution plans also help to identify the potential bottle necks, behaviour of optimization, role of indexes and distributioin statistics. <br /> In demo we will explore query execution, plan overview, plan caching and parameter sniffing