{"id":13515,"date":"2019-11-12T07:09:49","date_gmt":"2019-11-12T07:09:49","guid":{"rendered":"https:\/\/dbtut.com\/?p=13515"},"modified":"2019-11-12T07:09:50","modified_gmt":"2019-11-12T07:09:50","slug":"update-statistics-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/","title":{"rendered":"UPDATE STATISTICS in SQL Server"},"content":{"rendered":"

In this article, I will explain you to how to update your statistics with the UPDATE STATISTICS<\/code> command by table or database basis. I recommend that you read the article named “Statistic Concept and Performance Effect in SQL Server” before this article.<\/p>\n

Sample Commands<\/h1>\n

Update a Statistic<\/h2>\n

You can update the statistic of the index named AK_Department_Name in the Department table in the HumanResources schema with the help of the script below.<\/p>\n

USE AdventureWorks2014\nGO\u00a0\nUPDATE STATISTICS [HumanResources].[Department] [AK_Department_Name]\u00a0\nGO<\/pre>\n
Update All Statistics in a Table<\/h2>\n
You can update all statistics of the Department table in the HumanResource schema with the following script.<\/p>\n
USE AdventureWorks2014\nGO\u00a0\nUPDATE STATISTICS [HumanResources].[Department]\nGO<\/pre>\n
Update All Statistics in a Database<\/h2>\n
You can update all statistics of the Database with the following script.<\/p>\n
USE AdventureWorks2014\nGO\u00a0\nEXEC sp_updatestats<\/pre>\n
Update Statistic Options<\/h2>\n
    \n
  1. FULLSCAN<\/li>\n
  2. SAMPLE<\/li>\n
  3. RESAMPLE<\/li>\n<\/ol>\n
    FULLSCAN<\/h3>\n
    This method updates the statistic by scanning all rows of the related table or indexed view. You can use it as follows.<\/p>\n
    USE AdventureWorks2014\nGO\u00a0\nUPDATE STATISTICS [HumanResources].[Department] [AK_Department_Name]\u00a0 WITH FULLSCAN\nGO<\/pre>\n
    SAMPLE<\/h3>\n
    Update the statistic by sampling the number or percentage of rows that you specify after the SAMPLE statement. You can use it in the following ways.<\/p>\n
    I update this statistic by sampling 10 rows. (The table has 16 rows)<\/p>\n
    You can learn the number of rows in the table with the help of the following queries.<\/p>\n
    Select Count(*) FROM [HumanResources].[Department]<\/pre>\n
    or<\/p>\n
    sp_spaceused '[HumanResources].[Department]'<\/pre>\n
    USE AdventureWorks2014\nGO\u00a0\nUPDATE STATISTICS [HumanResources].[Department] [AK_Department_Name]\u00a0 WITH SAMPLE 10 rows\nGO<\/pre>\n
    In the following script, it updates the statistic by sampling 50% of the number of rows of the related table or indexed view.<\/p>\n
    USE AdventureWorks2014\nGO\u00a0\nUPDATE STATISTICS [HumanResources].[Department] [AK_Department_Name]\u00a0 WITH SAMPLE 50 PERCENT\nGO<\/pre>\n
    RESAMPLE<\/h3>\n
    Updates the statistic according to the latest sample rate. For example, if you updated the statistic with WITH FULLSCAN previous time and if you run it with RESAMPLE next time, it will update the statistic with FULLSCAN.<\/p>\n
    You can use it as follows:<\/p>\n
    USE AdventureWorks2014\nGO\u00a0\nUPDATE STATISTICS [HumanResources].[Department] [AK_Department_Name]\u00a0 WITH RESAMPLE\nGO<\/pre>\n
    You can update all statistics of the Database with RESAMPLE.<\/p>\n
    EXEC sp_updatestats RESAMPLE<\/pre>\n
    NOTE: <\/strong>My advice is to update the statistics by default, without any parameters, unless there is a problem. Because the SQL Server Query Optimizer determines the sample rate itself to create the best query plan.<\/p>\n
    You can run the DBCC SHOW STATISTICS command to get detailed information about a statistic. You can find details in the article “DBCC SHOW_STATISTICS in SQL Server<\/a>“.<\/p>\n\n
    <\/div>\n
    <\/path><\/svg><\/i> \"Loading\"<\/p>\n
    <\/div>\n","protected":false},"excerpt":{"rendered":"
    In this article, I will explain you to how to update your statistics with the UPDATE STATISTICS command by table or database basis. I recommend that you read the article named “Statistic Concept and Performance Effect in SQL Server” before this article. Sample Commands Update a Statistic You can update the statistic of the index …<\/p>\n
    <\/div>\n
    <\/path><\/svg><\/i> \"Loading\"<\/p>\n
    <\/div>\n","protected":false},"author":1,"featured_media":13517,"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,1596],"tags":[5411,5413,5412,5416,295,5417,5410,5414,5421,5422,5402,5407,5403,5401,5404,5405,5406,5408,5420,5419,5418,5409,5415],"class_list":["post-13515","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","category-tsql","tag-index-update-statistics-sql-server","tag-mssql-statistics-update","tag-mssql-update-table-statistics","tag-mssql-update-table-statistics-resample","tag-sp_updatestats","tag-sp_updatestats-vs-update-statistics","tag-sql-server-update-statistics-all-tables","tag-sql-server-update-statistics-on-database","tag-update-a-specific-statistic","tag-update-a-specific-statistic-in-sql-server","tag-update-a-statistic","tag-update-all-database-statistics","tag-update-all-statistics-in-a-database","tag-update-all-statistics-in-a-table","tag-update-all-statistics-of-a-database","tag-update-all-statistics-of-a-table","tag-update-all-table-statistics","tag-update-statistic-options","tag-update-statistics-for-all-tables","tag-update-statistics-for-all-tables-and-databases","tag-update-statistics-for-all-tables-and-databases-in-a-sql","tag-update-statistics-in-sql-server-with-full-scan","tag-what-is-update-statistics-fullscan"],"aioseo_notices":[],"yoast_head":"\nUPDATE STATISTICS in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"UPDATE STATISTICS 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\/2019\/11\/12\/update-statistics-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"UPDATE STATISTICS in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"UPDATE STATISTICS in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-12T07:09:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-12T07:09:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-13.png\" \/>\n\t<meta property=\"og:image:width\" content=\"462\" \/>\n\t<meta property=\"og:image:height\" content=\"314\" \/>\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\/12\/update-statistics-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"UPDATE STATISTICS in SQL Server\",\"datePublished\":\"2019-11-12T07:09:49+00:00\",\"dateModified\":\"2019-11-12T07:09:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/\"},\"wordCount\":345,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-13.png\",\"keywords\":[\"index update statistics sql server\",\"mssql statistics update\",\"mssql update table statistics\",\"mssql update table statistics resample\",\"sp_updatestats\",\"sp_updatestats vs Update statistics\",\"sql server update statistics all tables\",\"sql server update statistics on database\",\"Update a specific statistic\",\"Update a specific statistic in sql server\",\"Update a Statistic\",\"Update all database statistics\",\"Update All Statistics in a Database\",\"Update All Statistics in a Table\",\"Update All Statistics of a Database\",\"Update All Statistics of a Table\",\"Update all table statistics\",\"Update Statistic Options\",\"Update Statistics for All Tables\",\"Update Statistics for All Tables and Databases\",\"Update Statistics for All Tables and Databases in a SQL\",\"update statistics in sql server with full scan\",\"What is update statistics Fullscan?\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/\",\"name\":\"UPDATE STATISTICS in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-13.png\",\"datePublished\":\"2019-11-12T07:09:49+00:00\",\"dateModified\":\"2019-11-12T07:09:50+00:00\",\"description\":\"UPDATE STATISTICS in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-13.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-13.png\",\"width\":462,\"height\":314},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"UPDATE STATISTICS 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":"UPDATE STATISTICS in SQL Server - Database Tutorials","description":"UPDATE STATISTICS 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\/2019\/11\/12\/update-statistics-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"UPDATE STATISTICS in SQL Server - Database Tutorials","og_description":"UPDATE STATISTICS in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-11-12T07:09:49+00:00","article_modified_time":"2019-11-12T07:09:50+00:00","og_image":[{"width":462,"height":314,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-13.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\/12\/update-statistics-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"UPDATE STATISTICS in SQL Server","datePublished":"2019-11-12T07:09:49+00:00","dateModified":"2019-11-12T07:09:50+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/"},"wordCount":345,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-13.png","keywords":["index update statistics sql server","mssql statistics update","mssql update table statistics","mssql update table statistics resample","sp_updatestats","sp_updatestats vs Update statistics","sql server update statistics all tables","sql server update statistics on database","Update a specific statistic","Update a specific statistic in sql server","Update a Statistic","Update all database statistics","Update All Statistics in a Database","Update All Statistics in a Table","Update All Statistics of a Database","Update All Statistics of a Table","Update all table statistics","Update Statistic Options","Update Statistics for All Tables","Update Statistics for All Tables and Databases","Update Statistics for All Tables and Databases in a SQL","update statistics in sql server with full scan","What is update statistics Fullscan?"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/","name":"UPDATE STATISTICS in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-13.png","datePublished":"2019-11-12T07:09:49+00:00","dateModified":"2019-11-12T07:09:50+00:00","description":"UPDATE STATISTICS in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-13.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-13.png","width":462,"height":314},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/update-statistics-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"UPDATE STATISTICS 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\/13515","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=13515"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13515\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13517"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}