{"id":13156,"date":"2019-10-07T09:20:08","date_gmt":"2019-10-07T09:20:08","guid":{"rendered":"https:\/\/dbtut.com\/?p=13156"},"modified":"2019-10-07T14:00:55","modified_gmt":"2019-10-07T14:00:55","slug":"how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/","title":{"rendered":"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option"},"content":{"rendered":"<p><strong>COLUMNSTORE_ARCHIVE<\/strong> option was introduced with SQL Server 2014. If we want to archive ColumnStore Tables or Indexes, we can compress our columnstore tables or indexes with this option.<\/p>\n<p>For example, you partitioned a columnstore table by a date column. And you want to save space by compressing old partitions. In this case, you can compress old partitions with COLUMNSTORE_ARCHIVE option. So you can save up to 15 times.<\/p>\n<h2>Compress a ColumnStore Table<\/h2>\n<pre class=\"lang:default decode:true \">ALTER TABLE ColumnstoreTableName REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = COLUMNSTORE_ARCHIVE) ; \n<\/pre>\n<h2>Decompress a ColumnStore Table<\/h2>\n<pre class=\"lang:default decode:true \">ALTER TABLE ColumnstoreTableName REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = COLUMNSTORE) ; \n<\/pre>\n<h2>Compress a ColumnStore Index<\/h2>\n<pre class=\"lang:default decode:true \">ALTER Index ColumnStoreIndexName ON TableName REBUILD  WITH (DATA_COMPRESSION = COLUMNSTORE_ARCHIVE);<\/pre>\n<h2>Decompress a ColumnStore Index<\/h2>\n<pre class=\"lang:default decode:true \">ALTER Index ColumnStoreIndexName ON TableName REBUILD  WITH (DATA_COMPRESSION = COLUMNSTORE);  \n<\/pre>\n<h2>Comress Only Some Partitions on a ColumnStore Table<\/h2>\n<pre class=\"lang:default decode:true \">ALTER TABLE ColumnstoreTableName REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = COLUMNSTORE ON PARTITIONS (1,3) ) ; \n<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13156\" class=\"pvc_stats all  \" data-element-id=\"13156\" 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>COLUMNSTORE_ARCHIVE option was introduced with SQL Server 2014. If we want to archive ColumnStore Tables or Indexes, we can compress our columnstore tables or indexes with this option. For example, you partitioned a columnstore table by a date column. And you want to save space by compressing old partitions. In this case, you can compress &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13156\" class=\"pvc_stats all  \" data-element-id=\"13156\" 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":13162,"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":[4857,4858,4852,4851,4855,4853,4856,4854],"class_list":["post-13156","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-archive-columnstore-index","tag-archive-columnstore-table","tag-columnstore_archive","tag-columnstore_archive-option","tag-compress-a-columnstore-index","tag-compress-a-columnstore-table","tag-decompress-a-columnstore-index","tag-decompress-a-columnstore-table"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option\" \/>\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\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-07T09:20:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-07T14:00:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"648\" \/>\n\t<meta property=\"og:image:height\" content=\"382\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option\",\"datePublished\":\"2019-10-07T09:20:08+00:00\",\"dateModified\":\"2019-10-07T14:00:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/\"},\"wordCount\":106,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-1.png\",\"keywords\":[\"ARCHIVE COLUMNSTORE INDEX\",\"ARCHIVE COLUMNSTORE TABLE\",\"COLUMNSTORE_ARCHIVE\",\"COLUMNSTORE_ARCHIVE Option\",\"Compress a ColumnStore Index\",\"Compress a ColumnStore Table\",\"Decompress a ColumnStore Index\",\"Decompress a ColumnStore Table\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/\",\"name\":\"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-1.png\",\"datePublished\":\"2019-10-07T09:20:08+00:00\",\"dateModified\":\"2019-10-07T14:00:55+00:00\",\"description\":\"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-1.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-1.png\",\"width\":648,\"height\":382},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option\"}]},{\"@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":"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option - Database Tutorials","description":"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option","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\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/","og_locale":"en_US","og_type":"article","og_title":"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option - Database Tutorials","og_description":"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option","og_url":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/","og_site_name":"Database Tutorials","article_published_time":"2019-10-07T09:20:08+00:00","article_modified_time":"2019-10-07T14:00:55+00:00","og_image":[{"width":648,"height":382,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-1.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option","datePublished":"2019-10-07T09:20:08+00:00","dateModified":"2019-10-07T14:00:55+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/"},"wordCount":106,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-1.png","keywords":["ARCHIVE COLUMNSTORE INDEX","ARCHIVE COLUMNSTORE TABLE","COLUMNSTORE_ARCHIVE","COLUMNSTORE_ARCHIVE Option","Compress a ColumnStore Index","Compress a ColumnStore Table","Decompress a ColumnStore Index","Decompress a ColumnStore Table"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/","url":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/","name":"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-1.png","datePublished":"2019-10-07T09:20:08+00:00","dateModified":"2019-10-07T14:00:55+00:00","description":"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-1.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-1.png","width":648,"height":382},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/07\/how-to-compress-columnstore-tables-and-indexes-with-columnstore_archive-option\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option"}]},{"@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\/13156","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=13156"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13156\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13162"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}