{"id":142,"date":"2015-12-08T08:02:35","date_gmt":"2015-12-08T08:02:35","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=142"},"modified":"2015-12-08T16:28:40","modified_gmt":"2015-12-08T16:28:40","slug":"alter-index-enable-index-disable-index","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2015\/12\/08\/alter-index-enable-index-disable-index\/","title":{"rendered":"Alter index enable index disable index"},"content":{"rendered":"<p><a data-topotext=\"[{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{&quot;style&quot;:3},&quot;uniqueId&quot;:5},&quot;codePoints&quot;:[85,83,69,32,65,100,118,101,110,116,117,114,101,87,111,114,107,115,10,71,79,10,45,45,45,45,68,105,97,98,108,101,160,73,110,100,101,120,10,65,76,84,69,82,160,73,78,68,69,88,32,91,73,88,95,83,116,111,114,101,67,111,110,116,97,99,116,95,67,111,110,116,97,99,116,84,121,112,101,73,68,93,32,79,78,32,83,97,108,101,115,46,83,116,111,114,101,67,111,110,116,97,99,116,160,68,73,83,65,66,76,69,10,71,79,10,45,45,45,45,69,110,97,98,108,101,160,73,110,100,101,120,10,65,76,84,69,82,160,73,78,68,69,88,32,91,73,88,95,83,116,111,114,101,67,111,110,116,97,99,116,95,67,111,110,116,97,99,116,84,121,112,101,73,68,93,32,79,78,32,83,97,108,101,115,46,83,116,111,114,101,67,111,110,116,97,99,116,160,82,69,66,85,73,76,68,10,71,79,10,10,45,45,45,45,68,105,97,98,108,101,160,73,110,100,101,120,10,65,76,84,69,82,160,73,78,68,69,88,32,91,73,88,95,99,105,100,93,32,79,78,32,83,97,108,101,115,46,83,116,111,114,101,67,111,110,116,97,99,116,160,68,73,83,65,66,76,69,10,71,79,10,45,45,45,45,69,110,97,98,108,101,160,73,110,100,101,120,10,65,76,84,69,82,160,73,78,68,69,88,32,91,73,88,95,83,116,111,114,101,67,111,110,116,97,99,116,95,67,111,110,116,97,99,116,84,121,112,101,73,68,93,32,79,78,32,83,97,108,101,115,46,83,116,111,114,101,67,111,110,116,97,99,116,160,82,69,66,85,73,76,68,10,71,79,10,10]}]\">\u200b<\/a><\/p>\n<div>USE AdventureWorks<\/div>\n<div>GO<\/div>\n<div>&#8212;-Diable\u00a0Index<\/div>\n<div>ALTER\u00a0INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact\u00a0DISABLE<\/div>\n<div>GO<\/div>\n<div>&#8212;-Enable\u00a0Index<\/div>\n<div>ALTER\u00a0INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact\u00a0REBUILD<\/div>\n<div>GO<\/div>\n<div><\/div>\n<div>&#8212;-Diable\u00a0Index<\/div>\n<div>ALTER\u00a0INDEX [IX_cid] ON Sales.StoreContact\u00a0DISABLE<\/div>\n<div>GO<\/div>\n<div>&#8212;-Enable\u00a0Index<\/div>\n<div>ALTER\u00a0INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact\u00a0REBUILD<\/div>\n<div>GO<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u200b USE AdventureWorks GO &#8212;-Diable\u00a0Index ALTER\u00a0INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact\u00a0DISABLE GO &#8212;-Enable\u00a0Index ALTER\u00a0INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact\u00a0REBUILD GO &#8212;-Diable\u00a0Index ALTER\u00a0INDEX [IX_cid] ON Sales.StoreContact\u00a0DISABLE GO &#8212;-Enable\u00a0Index ALTER\u00a0INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact\u00a0REBUILD GO<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-142","post","type-post","status-publish","format-standard","hentry","category-mssql"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=142"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/142\/revisions"}],"predecessor-version":[{"id":143,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/142\/revisions\/143"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}