This is a dedicated watch page for a single video.
SQL Server uses what is known as cost-based query optimizer. The query optimizer calculates a cost for multiple possible plans based on the statistics it has on the columns being utilized, and the possible indexes that can be used for each operation in each query plan. The engine uses a number of factors when building a plan including compatibility level of the database, row estimates based on statistics and available indexes. The most common tool used to view and save graphical query plans is SQL Server Management Studio. Which are the different types of execution plans that can be viewed? (Select three)