{"id":14016,"date":"2019-11-25T08:01:55","date_gmt":"2019-11-25T08:01:55","guid":{"rendered":"https:\/\/dbtut.com\/?p=14016"},"modified":"2019-11-25T17:51:14","modified_gmt":"2019-11-25T17:51:14","slug":"auto-update-statistics-in-memory-optimized-tables","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/","title":{"rendered":"Auto Update Statistics in Memory Optimized Tables"},"content":{"rendered":"<p>With SQL Server 2016, support for automatic update statistics in Memory Optimized Tables is available. If the database is created with compatibility level 130, nothing is required. However, if the database was created with an earlier compatibility level, it is necessary to update the statistics manually once the compatibility level has been upgraded to 130.<\/p>\n<p>You may be interested in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/what-is-sql-server-database-compatibility-level-and-how-to-change-database-compatibility-level\/\" target=\"_blank\" rel=\"bookmark noopener noreferrer\">What is SQL Server Database Compatibility Level and How To Change Database Compatibility Level<\/a>&#8221;<\/p>\n<p>I also recommend you to read the following articles about statistics.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/statistic-concept-and-performance-effect-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Statistic Concept and Performance Effect on SQL Server<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">UPDATE STATISTICS in SQL Server<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/10\/21\/dbcc-show_statistics-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">DBCC SHOW\u00a0 STATISTICS in SQL Server<\/a>&#8221;<\/p>\n<h2>Check Auto Update Statistics Enabled<\/h2>\n<p>You need to check whether automatic statistics update is enabled in the database. If not, you must enable. Right-click on the database, select properties, and then click on the options tab to see if Auto Update Statistics is True.<\/p>\n<p id=\"bWnmnsq\"><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"148\" class=\"size-full wp-image-14017  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/img_5ddb87c7be0db.png\" alt=\"\" \/><\/p>\n<h2>Enable Auto Update Statistics<\/h2>\n<pre class=\"lang:default decode:true\">ALTER DATABASE your_database_name SET AUTO_UPDATE_STATISTICS ON;<\/pre>\n<h2>Check Auto Update Statistics Enabled in Memory Optimized Tables<\/h2>\n<p>You can check whether automatic update statistics is enabled in memory optimized tables with the help of the following script.<\/p>\n<pre class=\"lang:default decode:true \">SELECT \n    QUOTENAME(SCHEMA_NAME(tbl.schema_id)) + N'.' + QUOTENAME(tbl.name) AS [tablo_ismi],\n    st.name AS [istatistik ismi],\n   CASE  1-st.no_recompute \n   WHEN 0 THEN 'HAYIR' \n   WHEN 1 THEN 'EVET' \n   END AS [otomatik g\u00fcncelleme aktif mi?]\nFROM sys.stats st JOIN sys.tables tbl ON st.object_id=tbl.object_id\nWHERE tbl.is_memory_optimized=1\n<\/pre>\n<h2>Update Statistics for Memory-Optimized Tables<\/h2>\n<p>If automatic statistics update is not enabled, you can use the following script to manually update statistics. The query will give you a script. You should run this script.<\/p>\n<pre class=\"lang:default decode:true\">DECLARE @query NVARCHAR(MAX) = N'';\nSELECT\n      @query += N'UPDATE STATISTICS '\n         + quotename(schema_name(tbl.schema_id))\n         + N'.'\n         + quotename(tbl.name)\n         + ';' + CHAR(13) + CHAR(10)\n   FROM sys.tables AS tbl\n   WHERE tbl.is_memory_optimized = 1 AND \n        tbl.object_id IN (SELECT object_id FROM sys.stats WHERE no_recompute=1)\n\nSELECT @query\n<\/pre>\n<p>Finally, you must also manually recompile Natively compiled stored procedures to take advantage of the statistics update.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14016\" class=\"pvc_stats all  \" data-element-id=\"14016\" 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>With SQL Server 2016, support for automatic update statistics in Memory Optimized Tables is available. If the database is created with compatibility level 130, nothing is required. However, if the database was created with an earlier compatibility level, it is necessary to update the statistics manually once the compatibility level has been upgraded to 130. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14016\" class=\"pvc_stats all  \" data-element-id=\"14016\" 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":14018,"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":[292,6333,6331,6330,6329,6323,6327,6328,6324,6326,6325,6322,6332,6336,6334,6335],"class_list":["post-14016","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-auto-update-statistics","tag-auto-update-statistics-for-memory-optimized-tables","tag-auto-update-statistics-memory-optimized-table","tag-auto-update-statistics-on-sql-server","tag-auto-update-statistics-sql-server-2016","tag-check-auto-update-statistics","tag-check-auto-update-statistics-enabled","tag-check-auto-update-statistics-enabled-in-memory-optimized-tables","tag-check-auto-update-statistics-is-enabled","tag-check-auto-update-statistics-is-set-true","tag-check-auto-update-statistics-is-true","tag-enable-auto-update-statistics","tag-statistics-for-memory-optimized-tables","tag-update-statistics-for-memory-optimized-tables-in-sql-server","tag-updating-statistics-for-memory-optimized-tables","tag-updating-statistics-for-memory-optimized-tables-in-sql-server"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Auto Update Statistics in Memory Optimized Tables - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Auto Update Statistics in Memory Optimized Tables\" \/>\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\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Auto Update Statistics in Memory Optimized Tables - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Auto Update Statistics in Memory Optimized Tables\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-25T08:01:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-25T17:51:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-83.png\" \/>\n\t<meta property=\"og:image:width\" content=\"589\" \/>\n\t<meta property=\"og:image:height\" content=\"295\" \/>\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\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Auto Update Statistics in Memory Optimized Tables\",\"datePublished\":\"2019-11-25T08:01:55+00:00\",\"dateModified\":\"2019-11-25T17:51:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/\"},\"wordCount\":241,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-83.png\",\"keywords\":[\"Auto Update Statistics\",\"auto update Statistics for Memory-Optimized Tables\",\"auto update statistics memory optimized table\",\"auto update statistics on sql server\",\"auto update statistics sql server 2016\",\"Check Auto Update Statistics\",\"Check Auto Update Statistics Enabled\",\"Check Auto Update Statistics Enabled in Memory Optimized Tables\",\"Check Auto Update Statistics is enabled\",\"Check Auto Update Statistics is set true\",\"Check Auto Update Statistics is true\",\"Enable Auto Update Statistics\",\"Statistics for Memory-Optimized Tables\",\"Update statistics for Memory-Optimized tables in SQL Server\",\"Updating statistics for Memory-Optimized tables\",\"Updating statistics for Memory-Optimized tables in sql server\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/\",\"name\":\"Auto Update Statistics in Memory Optimized Tables - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-83.png\",\"datePublished\":\"2019-11-25T08:01:55+00:00\",\"dateModified\":\"2019-11-25T17:51:14+00:00\",\"description\":\"Auto Update Statistics in Memory Optimized Tables\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-83.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-83.png\",\"width\":589,\"height\":295},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Auto Update Statistics in Memory Optimized Tables\"}]},{\"@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":"Auto Update Statistics in Memory Optimized Tables - Database Tutorials","description":"Auto Update Statistics in Memory Optimized Tables","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\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/","og_locale":"en_US","og_type":"article","og_title":"Auto Update Statistics in Memory Optimized Tables - Database Tutorials","og_description":"Auto Update Statistics in Memory Optimized Tables","og_url":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/","og_site_name":"Database Tutorials","article_published_time":"2019-11-25T08:01:55+00:00","article_modified_time":"2019-11-25T17:51:14+00:00","og_image":[{"width":589,"height":295,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-83.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\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Auto Update Statistics in Memory Optimized Tables","datePublished":"2019-11-25T08:01:55+00:00","dateModified":"2019-11-25T17:51:14+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/"},"wordCount":241,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-83.png","keywords":["Auto Update Statistics","auto update Statistics for Memory-Optimized Tables","auto update statistics memory optimized table","auto update statistics on sql server","auto update statistics sql server 2016","Check Auto Update Statistics","Check Auto Update Statistics Enabled","Check Auto Update Statistics Enabled in Memory Optimized Tables","Check Auto Update Statistics is enabled","Check Auto Update Statistics is set true","Check Auto Update Statistics is true","Enable Auto Update Statistics","Statistics for Memory-Optimized Tables","Update statistics for Memory-Optimized tables in SQL Server","Updating statistics for Memory-Optimized tables","Updating statistics for Memory-Optimized tables in sql server"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/","url":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/","name":"Auto Update Statistics in Memory Optimized Tables - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-83.png","datePublished":"2019-11-25T08:01:55+00:00","dateModified":"2019-11-25T17:51:14+00:00","description":"Auto Update Statistics in Memory Optimized Tables","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-83.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-83.png","width":589,"height":295},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/25\/auto-update-statistics-in-memory-optimized-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Auto Update Statistics in Memory Optimized Tables"}]},{"@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\/14016","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=14016"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14016\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14018"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}