{"id":12076,"date":"2019-05-08T22:25:54","date_gmt":"2019-05-08T22:25:54","guid":{"rendered":"https:\/\/dbtut.com\/?p=12076"},"modified":"2019-05-08T22:26:32","modified_gmt":"2019-05-08T22:26:32","slug":"how-to-disable-and-enable-indexes-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/","title":{"rendered":"How To Disable and Enable Indexes in SQL Server"},"content":{"rendered":"<p>Indexes can be disabled in SQL Server 2005 and later versions. If the index is disabled, it is necessary to rebuild the index to enable it again. If you disable Clustered Index, the table with the clustered index will be inaccessible.<\/p>\n<p>Right click on the index you want to disable and click disable and you will see a screen like below. In this screen, it says; the index definition will be stored in metadata and if you want to re-enable the index, you should rebuild the index. You can disable it by clicking OK.<\/p>\n<p id=\"jsSQdoy\"><img loading=\"lazy\" decoding=\"async\" width=\"708\" height=\"399\" class=\"size-full wp-image-12078  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/img_5cd21cfd424b7.png\" alt=\"\" \/><\/p>\n<p>After you disable the Clustered Index, you will get an error as follows when you want to select the table.<\/p>\n<p><span style=\"color: #ff0000;\"><em>Msg 8655, Level 16, State 1, Line 2<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>The query processor is unable to produce a plan because the index &#8216;IX_Clustered&#8217; on table or view &#8216;FamousFood &#8216; is disabled.<\/em><\/span><\/p>\n<p>To re-enable a disable index, you must use the ALTER INDEX REBUILD or CREATE INDEX WITH DROP_EXISTING commands.<\/p>\n<h3>Index Rebuild Operation<\/h3>\n<pre class=\"lang:default decode:true \">ALTER INDEX [IX_Clustered] ON [dbo].[FamousFood ] REBUILD<\/pre>\n<h3>Drop Create Operation<\/h3>\n<pre class=\"lang:default decode:true \">CREATE UNIQUE CLUSTERED INDEX [IX_Clustered] ON [dbo].[FamousFood ]\n(\n\t[ID] ASC\n)WITH (DROP_EXISTING = ON)\n<\/pre>\n<p>One or more indexes can be disabled automatically during upgrade. So it is necessary to pay attention to this during the upgrade.<\/p>\n<p>Microsoft says that; &#8220;An index that uses system functions can bring a different result after the upgrade, or as a result of the collation change as part of the upgrade, the index can be sorted incorrectly, so this type of indexes will be disabled during the upgrade.&#8221;<\/p>\n<p>If an index is disabled during the upgrade, the index name and the corresponding constraint name are displayed as a warning message. Thus, you can enable these indexes by rebuilding after upgrade. If you do not disable index and rebuild without &#8220;DROP_EXISTING=ON&#8221;, you need extra space for both the old and new index during the index rebuild process.<\/p>\n<p>However, if you perform a rebuild process on another transaction after you disable the index, only about 20% temporary disk space is required for the sort operation. You do not need disk space except of this. You can disable unused indexes for a while before deleting them.<\/p>\n<p>You may want to browse the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-find-unused-indexes-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Find Unused Indexes in SQL Server<\/a>&#8221; to identify unused indexes.<\/p>\n<p>You can use the following script to find disabled indexes.<\/p>\n<pre class=\"lang:default decode:true \">SELECT o.name,i.name from sys.indexes i\n    INNER JOIN sys.objects o on o.object_id = i.object_id\nWHERE i.is_disabled = 1\nORDER BY o.name,i.name\n<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12076\" class=\"pvc_stats all  \" data-element-id=\"12076\" 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>Indexes can be disabled in SQL Server 2005 and later versions. If the index is disabled, it is necessary to rebuild the index to enable it again. If you disable Clustered Index, the table with the clustered index will be inaccessible. Right click on the index you want to disable and click disable and you &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12076\" class=\"pvc_stats all  \" data-element-id=\"12076\" 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":12081,"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":[3888,3891,3893,3889,3895,3892,3890,3899,3897,3901,3898,3896,3894,3900],"class_list":["post-12076","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-can-we-disable-index-in-sql-server","tag-disable-and-enable-indexes-in-sql-server","tag-disable-index-in-sql-server","tag-disable-indexes-in-sql-server","tag-drop_existingon","tag-enable-index-in-sql-server","tag-how-to-disable-an-index-in-sql-server","tag-rebuild-index-sql-server","tag-sql-server-disable-index-before-insert","tag-sql-server-disable-or-delete-index","tag-sql-server-disable-primary-key","tag-sql-server-enable-index-without-rebuild","tag-the-query-processor-is-unable-to-produce-a-plan-because-the-index-on-table-or-view-is-disabled","tag-tsql-enable-clustered-index"],"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 Disable and Enable Indexes in SQL Server - Database Tutorials<\/title>\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\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Disable and Enable Indexes in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Indexes can be disabled in SQL Server 2005 and later versions. If the index is disabled, it is necessary to rebuild the index to enable it again. If you disable Clustered Index, the table with the clustered index will be inaccessible. Right click on the index you want to disable and click disable and you &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-08T22:25:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-08T22:26:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-10.png\" \/>\n\t<meta property=\"og:image:width\" content=\"631\" \/>\n\t<meta property=\"og:image:height\" content=\"388\" \/>\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\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Disable and Enable Indexes in SQL Server\",\"datePublished\":\"2019-05-08T22:25:54+00:00\",\"dateModified\":\"2019-05-08T22:26:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/\"},\"wordCount\":380,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-10.png\",\"keywords\":[\"Can we disable index in SQL Server?\",\"disable and enable indexes in sql server\",\"disable index in sql server\",\"disable indexes in sql server\",\"DROP_EXISTING=ON\",\"enable index in sql server\",\"how to disable an index in sql server\",\"rebuild index sql server\",\"sql server disable index before insert\",\"sql server disable or delete index\",\"sql server disable primary key\",\"sql server enable index without rebuild\",\"The query processor is unable to produce a plan because the index on table or view is disabled\",\"tsql enable clustered index\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/\",\"name\":\"How To Disable and Enable Indexes in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-10.png\",\"datePublished\":\"2019-05-08T22:25:54+00:00\",\"dateModified\":\"2019-05-08T22:26:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-10.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-10.png\",\"width\":631,\"height\":388},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Disable and Enable Indexes 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":"How To Disable and Enable Indexes in SQL Server - Database Tutorials","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\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How To Disable and Enable Indexes in SQL Server - Database Tutorials","og_description":"Indexes can be disabled in SQL Server 2005 and later versions. If the index is disabled, it is necessary to rebuild the index to enable it again. If you disable Clustered Index, the table with the clustered index will be inaccessible. Right click on the index you want to disable and click disable and you &hellip;","og_url":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-05-08T22:25:54+00:00","article_modified_time":"2019-05-08T22:26:32+00:00","og_image":[{"width":631,"height":388,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-10.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\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Disable and Enable Indexes in SQL Server","datePublished":"2019-05-08T22:25:54+00:00","dateModified":"2019-05-08T22:26:32+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/"},"wordCount":380,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-10.png","keywords":["Can we disable index in SQL Server?","disable and enable indexes in sql server","disable index in sql server","disable indexes in sql server","DROP_EXISTING=ON","enable index in sql server","how to disable an index in sql server","rebuild index sql server","sql server disable index before insert","sql server disable or delete index","sql server disable primary key","sql server enable index without rebuild","The query processor is unable to produce a plan because the index on table or view is disabled","tsql enable clustered index"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/","name":"How To Disable and Enable Indexes in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-10.png","datePublished":"2019-05-08T22:25:54+00:00","dateModified":"2019-05-08T22:26:32+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-10.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-10.png","width":631,"height":388},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/08\/how-to-disable-and-enable-indexes-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Disable and Enable Indexes 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\/12076","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=12076"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12076\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12081"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12076"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12076"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12076"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}