{"id":51,"date":"2009-10-13T17:10:01","date_gmt":"2009-10-13T22:10:01","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=51"},"modified":"2014-11-13T14:05:14","modified_gmt":"2014-11-13T19:05:14","slug":"execution-plan-inaccuracies","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/","title":{"rendered":"Execution Plan Inaccuracies"},"content":{"rendered":"

Execution plans are a great tool when you are trying to performance tune your SQL code. They contain a lot of information about how SQL Server will achieve what we have asked it to do. You can see which way tables are accessed, how many rows are read, where data is sorted and so on. But you have to be careful when using them. You probably already know, that there are two types of Execution Plans. The Estimated Execution Plan you can get, without actually executing the query. This is an estimate of how SQL Server thinks it will execute the query and it is based manly on statistics of tables and indexes. The Actual Execution Plan on the other hand, SQL Server produces while actually executing the query. It contains information about ho much data was actually read and moved around.<\/span><\/span><\/p>\n

That the Estimated Execution Plan can be inaccurate is not a surprise, because it is an estimate. But even the Actual Execution Plan can contain vastly inaccurate data.<\/span><\/span><\/p>\n

Lets look at an example. First we create a table with the columns id, val1 and val2 and fill it with testing data:<\/span><\/span><\/p>\n\n\n<\/colgroup>\n\n\n
\n

CREATE<\/span> TABLE<\/span> dbo<\/span>.<\/span>TstData<\/span>(<\/span><\/span><\/span><\/p>\n

id INT<\/span> IDENTITY<\/span>(<\/span>1,<\/span>1)<\/span> PRIMARY<\/span> KEY<\/span> NONCLUSTERED<\/span>,<\/span><\/span><\/span><\/span><\/p>\n

val1 INT<\/span> NOT<\/span> NULL,<\/span><\/span><\/span><\/span><\/p>\n

val2 VARCHAR<\/span>(<\/span>MAX<\/span>)<\/span><\/span><\/span><\/span><\/p>\n

);<\/span><\/span><\/span><\/p>\n

INSERT<\/span> INTO<\/span> dbo<\/span>.<\/span>TstData<\/span>(<\/span>val1<\/span>,<\/span>val2<\/span>)<\/span><\/span><\/span><\/p>\n

SELECT<\/span> A<\/span>.<\/span>no<\/span>,<\/span>REPLICATE<\/span>(<\/span>CHAR<\/span>(<\/span>65<\/span>+(<\/span>B<\/span>.<\/span>no<\/span> %<\/span> 26<\/span>)),<\/span>A<\/span>.<\/span>no<\/span>)<\/span><\/span><\/span><\/p>\n

FROM<\/span> dbo<\/span>.<\/span>f_num<\/span>(<\/span>10<\/span>)<\/span> AS<\/span> A<\/span><\/span><\/span><\/p>\n

CROSS<\/span> JOIN<\/span> dbo<\/span>.<\/span>f_num<\/span>(<\/span>50<\/span>)<\/span> AS<\/span> B<\/span>;<\/span><\/span><\/span><\/p>\n

GO<\/span><\/span><\/span><\/p>\n

CREATE<\/span> CLUSTERED<\/span> INDEX<\/span> TstData_CI<\/span> ON<\/span> dbo<\/span>.<\/span>TstData<\/span>(<\/span>val1<\/span>);<\/span><\/span><\/span><\/p>\n

GO<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Then we create a view that concatenates the val2 columns together in id order, grouped by val1.<\/span><\/span><\/p>\n

So if the data in dbo.TstData looked like this:<\/span><\/span><\/p>\n

\"\"<\/p>\n

the view would return this:<\/span><\/span><\/p>\n

\"\"<\/p>\n

This is the code for this first view:<\/span><\/span><\/p>\n\n\n<\/colgroup>\n\n\n
\n

CREATE VIEW dbo<\/span>.<\/span>TstVw1<\/span><\/span><\/span><\/span><\/p>\n

AS<\/span><\/span><\/span><\/p>\n

SELECT<\/span> DISTINCT<\/span> A<\/span>.<\/span>val1<\/span>,<\/span>C<\/span>.<\/span>Cnct<\/span><\/span><\/span><\/p>\n

FROM<\/span> dbo<\/span>.<\/span>TstData<\/span> AS<\/span> A<\/span><\/span><\/span><\/p>\n

CROSS<\/span> APPLY(<\/span>SELECT<\/span> (<\/span>SELECT<\/span> B<\/span>.<\/span>val2 [text language=\"()\"][\/text]<\/span><\/span><\/span><\/p>\n

FROM<\/span> dbo<\/span>.<\/span>TstData<\/span> AS<\/span> B<\/span><\/span><\/span><\/p>\n

WHERE<\/span> B<\/span>.<\/span>val1<\/span> =<\/span> A<\/span>.<\/span>val1<\/span><\/span><\/span><\/p>\n

ORDER<\/span> BY<\/span> B<\/span>.<\/span>id<\/span><\/span><\/span><\/p>\n

FOR<\/span> XML<\/span> PATH<\/span>(<\/span>''<\/span>)<\/span><\/span><\/span><\/p>\n

)<\/span> AS<\/span> Cnct<\/span><\/span><\/span><\/p>\n

)<\/span> AS<\/span> C<\/span>;<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

It is using SQL Servers XML capabilities to do the concatenation.<\/span><\/span><\/p>\n

Next we create a second view that does exactly the same thing, but instead of XML it is using a SQL function that cursors through all rows of the table to get there:<\/span><\/span><\/p>\n\n\n<\/colgroup>\n\n\n
\n

CREATE<\/span> FUNCTION<\/span> dbo<\/span>.<\/span>TstDataConcat<\/span>(<\/span><\/span><\/span><\/p>\n

@GrpVal INT<\/span><\/span><\/span><\/span><\/p>\n

)<\/span><\/span><\/span><\/p>\n

RETURNS<\/span> VARCHAR<\/span>(<\/span>MAX<\/span>)<\/span><\/span><\/span><\/p>\n

AS<\/span><\/span><\/span><\/p>\n

BEGIN<\/span><\/span><\/span><\/p>\n

DECLARE<\/span> @Cnct<\/span> VARCHAR<\/span>(<\/span>MAX<\/span>);<\/span><\/span><\/span><\/p>\n

DECLARE<\/span> @Val1<\/span> INT<\/span>;<\/span><\/span><\/span><\/p>\n

DECLARE<\/span> @Val2<\/span> VARCHAR<\/span>(<\/span>MAX<\/span>);<\/span><\/span><\/span><\/p>\n

SET<\/span> @Cnct<\/span> =<\/span> ''<\/span>;<\/span><\/span><\/span><\/p>\n

DECLARE<\/span> cur<\/span> CURSOR<\/span> LOCAL<\/span> FAST_FORWARD<\/span><\/span><\/span><\/p>\n

FOR<\/span> SELECT<\/span> val1<\/span>,<\/span>val2<\/span><\/span><\/span><\/p>\n

FROM<\/span> dbo<\/span>.<\/span>TstData<\/span><\/span><\/span><\/p>\n

ORDER<\/span> BY<\/span> id<\/span>;<\/span><\/span><\/span><\/p>\n

OPEN<\/span> cur<\/span>;<\/span><\/span><\/span><\/p>\n

FETCH<\/span> NEXT<\/span> FROM<\/span> cur<\/span> INTO<\/span> @Val1<\/span>,<\/span> @Val2<\/span>;<\/span><\/span><\/span><\/p>\n

WHILE<\/span>(<\/span>@@FETCH_STATUS<\/span> =<\/span> 0<\/span>)<\/span><\/span><\/span><\/p>\n

BEGIN<\/span><\/span><\/span><\/p>\n

IF<\/span>(<\/span>@Val1<\/span> =<\/span> @GrpVal<\/span>)<\/span><\/span><\/span><\/p>\n

BEGIN<\/span><\/span><\/span><\/p>\n

SET<\/span> @Cnct<\/span> +=<\/span> @Val2<\/span>;<\/span><\/span><\/span><\/p>\n

END<\/span><\/span><\/span><\/p>\n

FETCH<\/span> NEXT<\/span> FROM<\/span> cur<\/span> INTO<\/span> @Val1<\/span>,<\/span> @Val2<\/span>;<\/span><\/span><\/span><\/p>\n

END<\/span><\/span><\/span><\/p>\n

CLOSE<\/span> cur<\/span>;<\/span><\/span><\/span><\/p>\n

DEALLOCATE<\/span> cur<\/span>;<\/span><\/span><\/span><\/p>\n

RETURN<\/span> @Cnct<\/span>;<\/span><\/span><\/span><\/p>\n

END<\/span><\/span><\/span><\/p>\n

GO<\/span><\/span><\/span><\/p>\n

CREATE<\/span> VIEW<\/span> dbo<\/span>.<\/span>TstVw2<\/span><\/span><\/span><\/p>\n

AS<\/span><\/span><\/span><\/p>\n

SELECT<\/span> val1<\/span>,<\/span>dbo<\/span>.<\/span>TstDataConcat<\/span>(<\/span>val1<\/span>)<\/span> AS<\/span> Cnct<\/span><\/span><\/span><\/p>\n

FROM<\/span> dbo<\/span>.<\/span>TstData<\/span><\/span><\/span><\/p>\n

GROUP<\/span> BY<\/span> val1<\/span>;<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The function this view is using is intentionally not well optimized.<\/span><\/span><\/p>\n

When we compare the performance of a<\/span><\/span><\/span><\/span><\/span> SELECT<\/span><\/span><\/span>*<\/span><\/span><\/span>INTO<\/span><\/span><\/span>#tst1<\/span><\/span><\/span> FROM<\/span><\/span><\/span>dbo<\/span><\/span><\/span>.<\/span><\/span><\/span>TstVw1<\/span><\/span><\/span>;<\/span><\/span><\/span>with it's counterpart using<\/span><\/span><\/span><\/span><\/span> dbo<\/span><\/span><\/span><\/span><\/span><\/span>.<\/span><\/span><\/span><\/span><\/span><\/span>TstVw2<\/span><\/span><\/span><\/span><\/span><\/span>, by looking at the actual execution plan we find a clear indication, that the XML version is a lot more complicated:<\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n

\"\"
\n<\/span><\/p>\n

SQL Server is telling us that the cost of the XML version is 0.640 or 94% of the batch. The cursor version is declared to cost a mere 0.042 or 6% of the batch. Below is an exerpt from the XML execution plan, containing some additional information about this.<\/span><\/p>\n\n\n<\/colgroup>\n\n\n
\n

<<\/span><\/span><\/span><\/span><\/span>StmtSimple<\/span><\/span><\/span><\/span><\/span>StatementEstRows<\/span><\/span><\/span><\/span><\/span>=<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>107.495<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>StatementOptmLevel<\/span><\/span><\/span><\/span><\/span>=<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>FULL<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>StatementOptmEarlyAbortReason<\/span><\/span><\/span><\/span><\/span>=<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>GoodEnoughPlanFound<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>StatementSubTreeCost<\/strong><\/span><\/span><\/span><\/span>=<\/strong><\/span><\/span><\/span><\/span>\"<\/strong><\/span><\/span><\/span><\/span>0.640166<\/strong><\/span><\/span><\/span><\/span>\"<\/strong><\/span><\/span><\/span><\/span>StatementText<\/span><\/span><\/span><\/span><\/span>=<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>SELECT * INTO #tst1 FROM dbo.TstVw1;<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>StatementType<\/span><\/span><\/span><\/span><\/span>=<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>SELECT INTO<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n

<QueryPlan<\/span> DegreeOfParallelism<\/span>=\"<\/span>0\"<\/span> MemoryGrant<\/span>=\"<\/span>6656\"<\/span> CachedPlanSize<\/span>=\"<\/span>48\"<\/span> CompileTime<\/span>=\"<\/span>6\"<\/span> CompileCPU<\/span>=\"<\/span>5\"<\/span> CompileMemory<\/span>=\"<\/span>224\"<\/span>><\/span><\/span><\/span><\/p>\n

<StmtSimple<\/span> StatementEstRows<\/span>=\"<\/span>10\"<\/span> StatementOptmLevel<\/span>=\"<\/span>FULL\"<\/span> StatementOptmEarlyAbortReason<\/span>=\"<\/span>GoodEnoughPlanFound\"<\/span> StatementSubTreeCost<\/strong><\/span>=<\/strong>\"<\/strong><\/span>0.0420384<\/strong>\"<\/strong><\/span> StatementText<\/span>=\"<\/span>SELECT * INTO #tst2 FROM dbo.TstVw2;\"<\/span> StatementType<\/span>=\"<\/span>SELECT INTO\"<\/span>><\/span><\/span><\/span><\/p>\n

<<\/span><\/span><\/span><\/span><\/span>QueryPlan<\/span><\/span><\/span><\/span><\/span>DegreeOfParallelism<\/span><\/span><\/span><\/span><\/span>=<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>0<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>CachedPlanSize<\/span><\/span><\/span><\/span><\/span>=<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>40<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>CompileTime<\/span><\/span><\/span><\/span><\/span>=<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>11<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>CompileCPU<\/span><\/span><\/span><\/span><\/span>=<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>8<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>CompileMemory<\/span><\/span><\/span><\/span><\/span>=<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>112<\/span><\/span><\/span><\/span><\/span>\"<\/span><\/span><\/span><\/span><\/span>><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

So according to the actual execution plan the cursor version is over 15 times faster than the XML version.<\/span><\/p>\n

Now, we all know that this result is very unlikely, and when we look at the output of the comparison with<\/span> STATISTICS<\/span><\/span><\/span>TIME<\/span><\/span><\/span>ON<\/span><\/span><\/span>, we get these a lot more realistic results:<\/span><\/span><\/p>\n\n\n<\/colgroup>\n\n\n
\n

starting tst1 (CROSS APPLY)<\/span><\/span><\/p>\n

DBCC execution completed. If DBCC printed error messages, contact your system administrator.<\/span><\/span><\/p>\n

DBCC execution completed. If DBCC printed error messages, contact your system administrator.<\/span><\/span><\/p>\n

(10 row(s) affected)<\/span><\/span><\/p>\n

(1 row(s) affected)<\/span><\/span><\/p>\n

SQL Server Execution Times:<\/span><\/span><\/p>\n

CPU time = 47 ms, elapsed time = 51 ms.<\/span><\/span><\/p>\n

starting tst2 (FUNCTION)<\/span><\/span><\/p>\n

DBCC execution completed. If DBCC printed error messages, contact your system administrator.<\/span><\/span><\/p>\n

DBCC execution completed. If DBCC printed error messages, contact your system administrator.<\/span><\/span><\/p>\n

(10 row(s) affected)<\/span><\/span><\/p>\n

(1 row(s) affected)<\/span><\/span><\/p>\n

SQL Server Execution Times:<\/span><\/span><\/p>\n

CPU time = 2797 ms, elapsed time = 3067 ms.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

That is 47ms for the XML version compared to almost 3 seconds for the cursor. That means, eventhough the Execution Plan said the XML solution would be 15 times slower that the function, it ended up being close to 60 times faster.<\/span><\/span><\/span><\/p>\n

So, while Execution Plans are an invaluable tool for performance monitoring and tuning, you always have to be careful about the values it returns. The counts and the operators shown in the Actual Execution Plan are reliable, but the time comparisons can not always be relied on.<\/span><\/span><\/p>\n

If you want to try this for your self, you can download the full source here<\/a>.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Execution plans are a great tool when you are trying to performance tune your SQL code. They contain a lot of information about how SQL Server will achieve what we have asked it to do. You can see which way [more…]<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[5],"tags":[],"class_list":["post-51","post","type-post","status-publish","format-standard","hentry","category-general"],"acf":[],"yoast_head":"\nExecution Plan Inaccuracies<\/title>\n<meta name=\"description\" content=\"Execution Plans are a great performance tuning tool, however they can contain vastly inaccurate values so be certain to doublecheck\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Execution Plan Inaccuracies\" \/>\n<meta property=\"og:description\" content=\"Execution Plans are a great performance tuning tool, however they can contain vastly inaccurate values so be certain to doublecheck\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/\" \/>\n<meta property=\"og:site_name\" content=\"sqlity.net\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sqlity.net\" \/>\n<meta property=\"article:published_time\" content=\"2009-10-13T22:10:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T19:05:14+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/images.sqlity.net\/ExecutionPlan1_html_6909c154.gif\" \/>\n<meta name=\"author\" content=\"Sebastian Meine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sqlity\" \/>\n<meta name=\"twitter:site\" content=\"@sqlity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian Meine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"Execution Plan Inaccuracies\",\"datePublished\":\"2009-10-13T22:10:01+00:00\",\"dateModified\":\"2014-11-13T19:05:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/\"},\"wordCount\":869,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/images.sqlity.net\\\/ExecutionPlan1_html_6909c154.gif\",\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/\",\"name\":\"Execution Plan Inaccuracies\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/images.sqlity.net\\\/ExecutionPlan1_html_6909c154.gif\",\"datePublished\":\"2009-10-13T22:10:01+00:00\",\"dateModified\":\"2014-11-13T19:05:14+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"description\":\"Execution Plans are a great performance tuning tool, however they can contain vastly inaccurate values so be certain to doublecheck\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/#primaryimage\",\"url\":\"http:\\\/\\\/images.sqlity.net\\\/ExecutionPlan1_html_6909c154.gif\",\"contentUrl\":\"http:\\\/\\\/images.sqlity.net\\\/ExecutionPlan1_html_6909c154.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/51\\\/execution-plan-inaccuracies\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Execution Plan Inaccuracies\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\",\"name\":\"sqlity.net\",\"description\":\"Quality for SQL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlity.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\",\"name\":\"Sebastian Meine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"caption\":\"Sebastian Meine\"},\"sameAs\":[\"http:\\\/\\\/sqlity.net\",\"https:\\\/\\\/x.com\\\/sqlity\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Execution Plan Inaccuracies","description":"Execution Plans are a great performance tuning tool, however they can contain vastly inaccurate values so be certain to doublecheck","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:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/","og_locale":"en_US","og_type":"article","og_title":"Execution Plan Inaccuracies","og_description":"Execution Plans are a great performance tuning tool, however they can contain vastly inaccurate values so be certain to doublecheck","og_url":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2009-10-13T22:10:01+00:00","article_modified_time":"2014-11-13T19:05:14+00:00","og_image":[{"url":"http:\/\/images.sqlity.net\/ExecutionPlan1_html_6909c154.gif","type":"","width":"","height":""}],"author":"Sebastian Meine","twitter_card":"summary_large_image","twitter_creator":"@sqlity","twitter_site":"@sqlity","twitter_misc":{"Written by":"Sebastian Meine","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"Execution Plan Inaccuracies","datePublished":"2009-10-13T22:10:01+00:00","dateModified":"2014-11-13T19:05:14+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/"},"wordCount":869,"commentCount":0,"image":{"@id":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/#primaryimage"},"thumbnailUrl":"http:\/\/images.sqlity.net\/ExecutionPlan1_html_6909c154.gif","articleSection":["General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/","url":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/","name":"Execution Plan Inaccuracies","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/#primaryimage"},"image":{"@id":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/#primaryimage"},"thumbnailUrl":"http:\/\/images.sqlity.net\/ExecutionPlan1_html_6909c154.gif","datePublished":"2009-10-13T22:10:01+00:00","dateModified":"2014-11-13T19:05:14+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"description":"Execution Plans are a great performance tuning tool, however they can contain vastly inaccurate values so be certain to doublecheck","breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/#primaryimage","url":"http:\/\/images.sqlity.net\/ExecutionPlan1_html_6909c154.gif","contentUrl":"http:\/\/images.sqlity.net\/ExecutionPlan1_html_6909c154.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/51\/execution-plan-inaccuracies\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"Execution Plan Inaccuracies"}]},{"@type":"WebSite","@id":"https:\/\/sqlity.net\/en\/#website","url":"https:\/\/sqlity.net\/en\/","name":"sqlity.net","description":"Quality for SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlity.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c","name":"Sebastian Meine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","caption":"Sebastian Meine"},"sameAs":["http:\/\/sqlity.net","https:\/\/x.com\/sqlity"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-P","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/51","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/comments?post=51"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/51\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=51"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=51"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}