{"id":302,"date":"2018-06-18T21:07:16","date_gmt":"2018-06-18T21:07:16","guid":{"rendered":"http:\/\/dbtut.com\/?p=302"},"modified":"2020-01-30T11:14:50","modified_gmt":"2020-01-30T11:14:50","slug":"what-is-execution-plan-on-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/","title":{"rendered":"What is Execution Plan in SQL Server"},"content":{"rendered":"<h2>What is a execution plan in SQL?<\/h2>\n<p><span style=\"font-size: 1.125rem; font-family: var(--text-font);\">Execution plan is a road map that determines how the query will work.<\/span><\/p>\n<p><span lang=\"tr\">Will the query use the index or will it scan the table completely? <\/span><\/p>\n<p><span lang=\"tr\">What kind of join will it do? Nested loop, merge join, hash join etc.<\/span><\/p>\n<p><span lang=\"tr\">And it determines the query cost ratio for each part of the query. <\/span><\/p>\n<p><span lang=\"en-US\">For example, <\/span><span lang=\"tr\">an <\/span><span lang=\"en-US\">index seek process may have a query cost of 1%<\/span><\/p>\n<p lang=\"en-US\">When a TSQL query that you send to SQL Server runs slowly, the first thing you need to look is the query execution plan.<\/p>\n<h2 lang=\"en-US\">Execution Plan Types<\/h2>\n<p lang=\"en-US\">There are two types of execution plan as <strong>estimated execution plan<\/strong> and <strong>actual execution plan<\/strong>.<\/p>\n<h3 lang=\"en-US\">Estimated execution plan vs Actual execution plan<\/h3>\n<p lang=\"en-US\">Estimated execution plan predicts the execution plan to use if it is executed without executing the query.<\/p>\n<p lang=\"en-US\">The actual execution plan is the actual execution plan used after the query is executed.<\/p>\n<p>The best way to understand the execution plan is to go through an example.<\/p>\n<h3>Display estimated execution plan vs include actual execution plan<\/h3>\n<p>Open SQL Server Management Studio and when click on the Person.Adress Table in the AdventureWorks2014 database. Then click new query and write the following query.<\/p>\n<pre class=\"lang:default decode:true \">SELECT * FROM Person.Address<\/pre>\n<p lang=\"en-US\">Then click on the marked place in the picture below.<\/p>\n<p lang=\"en-US\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/901.png\" width=\"559\" height=\"453\"><\/p>\n<p>It predict that, if query will be executed, it will perform a Clustered Index Scan and the query cost was 100%.<\/p>\n<p>Let&#8217;s click on the arrow marked below and execute the query.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/916.png\" width=\"625\" height=\"330\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/528.png\" width=\"630\" height=\"333\"><\/p>\n<p><span lang=\"en-US\">As you can see, the query works and the execution plan is created. <\/span><\/p>\n<p><span lang=\"en-US\">Click on the underlined Execution Plan tab in the image above to see the actual execution plan. <\/span><\/p>\n<p><span lang=\"en-US\">In our <\/span><span lang=\"tr\">query<\/span><span lang=\"en-US\">, as you see below, the estimated and actual execution plan is same.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/860.png\" width=\"624\" height=\"468\"><\/p>\n<p>The following articles may interest you.<\/p>\n<p>&#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/06\/12\/index-concept-and-performance-effect-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Index Concept and Performance Effect on SQL Server<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/06\/13\/statistics-concept-and-performance-effect-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Statistical Concept and Performance Effect on SQL Server<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/06\/20\/join-types-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Join Types in SQL Server<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/06\/24\/spool-concept-in-execution-planeager-spool-lazy-spool\/\" target=\"_blank\" rel=\"noopener noreferrer\">Spool Concept in Execution Plan (Eager Spool, Lazy Spool)<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/06\/23\/join-types-in-sql-server-execution-plan\/\" target=\"_blank\" rel=\"noopener noreferrer\">Join Types in SQL Server Execution Plan<\/a>&#8221;<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_302\" class=\"pvc_stats all  \" data-element-id=\"302\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>What is a execution plan in SQL? Execution plan is a road map that determines how the query will work. Will the query use the index or will it scan the table completely? What kind of join will it do? Nested loop, merge join, hash join etc. And it determines the query cost ratio for &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_302\" class=\"pvc_stats all  \" data-element-id=\"302\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":14893,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[340,290,8197,8196,8192,8193,342,339,8189,8190,8191,334,8185,8195,338,4360,8199,171,187,341,343,337,336,345,8194,335,344,8186,8180,8176,172,186,8198,8188,8187,8178,8179,8175,8184,8174,8182,8183,8181],"class_list":["post-302","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-actual-execution-plan","tag-clustered-index-scan","tag-difference-between-actual-estimated-execution-plan-sql-server","tag-difference-between-actual-execution-plan-and-estimated-execution-plan-in-sql-server","tag-difference-between-estimated-execution-plan-and-actual-execution-plan","tag-display-estimated-execution-plan-vs-include-actual-execution-plan","tag-eager-spool","tag-estimated-execution-plan","tag-estimated-execution-plan-and-actual-execution-plan","tag-estimated-execution-plan-and-actual-execution-plan-in-sql-server","tag-estimated-execution-plan-vs-actual-execution-plan","tag-execution-plan","tag-execution-plan-in-sql-server","tag-execution-plan-types","tag-hash-join","tag-how-do-i-find-the-execution-plan-in-sql-server","tag-how-sql-query-is-executed","tag-index","tag-index-seek","tag-join-types","tag-lazy-spool","tag-merge-join","tag-nested-loop","tag-query-cost","tag-query-execution-plan","tag-query-plan","tag-spool","tag-sql-execution-plan","tag-sql-query-plan","tag-sql-server-execution-plan","tag-statistic","tag-table-scan","tag-what-is-a-execution-plan-in-sql","tag-what-is-actual-execution-plan","tag-what-is-estimated-execution-plan","tag-what-is-execution-plan-in-database","tag-what-is-execution-plan-in-sql","tag-what-is-execution-plan-in-sql-server","tag-what-is-execution-plan-in-sql-server-with-example","tag-what-is-execution-plan","tag-what-is-query-plan","tag-what-is-query-plan-in-sql-server","tag-what-is-sql-query-plan"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is Execution Plan in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"What is Execution Plan in SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Execution Plan in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"What is Execution Plan in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-18T21:07:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-30T11:14:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-43.png\" \/>\n\t<meta property=\"og:image:width\" content=\"449\" \/>\n\t<meta property=\"og:image:height\" content=\"294\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"What is Execution Plan in SQL Server\",\"datePublished\":\"2018-06-18T21:07:16+00:00\",\"dateModified\":\"2020-01-30T11:14:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/\"},\"wordCount\":341,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-43.png\",\"keywords\":[\"actual execution plan\",\"Clustered Index Scan\",\"difference between actual estimated execution plan sql server\",\"difference between actual execution plan and estimated execution plan in sql server\",\"difference between estimated execution plan and actual execution plan\",\"display estimated execution plan vs include actual execution plan\",\"Eager Spool\",\"Estimated execution plan\",\"estimated execution plan and actual execution plan\",\"estimated execution plan and actual execution plan in sql server\",\"estimated execution plan vs actual execution plan\",\"Execution Plan\",\"execution plan in sql server\",\"Execution Plan Types\",\"hash join\",\"How do I find the execution plan in SQL Server?\",\"How SQL query is executed?\",\"Index\",\"index seek\",\"join types\",\"Lazy Spool\",\"merge join\",\"Nested loop\",\"query cost\",\"query execution plan\",\"query plan\",\"Spool\",\"sql execution plan\",\"sql query plan\",\"sql server execution plan\",\"Statistic\",\"table scan\",\"What is a execution plan in SQL?\",\"what is actual execution plan\",\"what is estimated execution plan\",\"what is execution plan in database\",\"what is execution plan in sql\",\"what is execution plan in sql server\",\"what is execution plan in sql server with example\",\"What is Execution Plan?\",\"what is query plan\",\"what is query plan in sql server\",\"what is sql query plan\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/\",\"name\":\"What is Execution Plan in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-43.png\",\"datePublished\":\"2018-06-18T21:07:16+00:00\",\"dateModified\":\"2020-01-30T11:14:50+00:00\",\"description\":\"What is Execution Plan in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-43.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-43.png\",\"width\":449,\"height\":294},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is Execution Plan in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Execution Plan in SQL Server - Database Tutorials","description":"What is Execution Plan in SQL Server","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"What is Execution Plan in SQL Server - Database Tutorials","og_description":"What is Execution Plan in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-18T21:07:16+00:00","article_modified_time":"2020-01-30T11:14:50+00:00","og_image":[{"width":449,"height":294,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-43.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"What is Execution Plan in SQL Server","datePublished":"2018-06-18T21:07:16+00:00","dateModified":"2020-01-30T11:14:50+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/"},"wordCount":341,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-43.png","keywords":["actual execution plan","Clustered Index Scan","difference between actual estimated execution plan sql server","difference between actual execution plan and estimated execution plan in sql server","difference between estimated execution plan and actual execution plan","display estimated execution plan vs include actual execution plan","Eager Spool","Estimated execution plan","estimated execution plan and actual execution plan","estimated execution plan and actual execution plan in sql server","estimated execution plan vs actual execution plan","Execution Plan","execution plan in sql server","Execution Plan Types","hash join","How do I find the execution plan in SQL Server?","How SQL query is executed?","Index","index seek","join types","Lazy Spool","merge join","Nested loop","query cost","query execution plan","query plan","Spool","sql execution plan","sql query plan","sql server execution plan","Statistic","table scan","What is a execution plan in SQL?","what is actual execution plan","what is estimated execution plan","what is execution plan in database","what is execution plan in sql","what is execution plan in sql server","what is execution plan in sql server with example","What is Execution Plan?","what is query plan","what is query plan in sql server","what is sql query plan"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/","name":"What is Execution Plan in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-43.png","datePublished":"2018-06-18T21:07:16+00:00","dateModified":"2020-01-30T11:14:50+00:00","description":"What is Execution Plan in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-43.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-43.png","width":449,"height":294},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/18\/what-is-execution-plan-on-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is Execution Plan in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=302"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/302\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14893"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}