{"id":161,"date":"2017-09-18T21:25:09","date_gmt":"2017-09-18T21:25:09","guid":{"rendered":"http:\/\/www.manualsqlserver.com\/?p=161"},"modified":"2020-05-20T04:00:55","modified_gmt":"2020-05-20T04:00:55","slug":"indices-modificacion","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=161","title":{"rendered":"Modificaci\u00f3n de Indices en SQL Server"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_AlterIndex02.png\" alt=\"\" class=\"wp-image-1268\" width=\"215\" height=\"221\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_AlterIndex02.png 300w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_AlterIndex02-291x300.png 291w\" sizes=\"auto, (max-width: 215px) 100vw, 215px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">Modificar un \u00edndice<\/h1>\n\n\n\n<p>Reindexar o reconstruir un \u00edndice es una operaci\u00f3n que se sugiere para planes de mantenimiento, esto reordena los registros y permite en ocasiones optimizar las consultas.<\/p>\n\n\n\n<!--more-->\n\n\n\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\"\n     style=\"display:block; text-align:center;\"\n     data-ad-layout=\"in-article\"\n     data-ad-format=\"fluid\"\n     data-ad-client=\"ca-pub-2636008503986218\"\n     data-ad-slot=\"1902193434\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<h3 class=\"wp-block-heading\">Modificaci\u00f3n de \u00cdndices<\/h3>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Instrucci\u00f3n Alter Index<\/strong><br>Modifica un \u00edndice en una tabla o vista. Al modificar se puede deshabilitar, reorganizar (reconstruir) o cambiar sus opciones.<\/p>\n\n\n\n<p><strong>Reconstruir un \u00edndice<\/strong><br>Alter index NombreIndice on Tabla\/Vista Rebuild<\/p>\n\n\n\n<p><strong>Reconstruir un \u00edndice modificando sus opciones<\/strong><br>Alter index NombreIndice on Tabla\/Vista Rebuild with (Opciones)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ejercicios<\/h3>\n\n\n\n<p>Usando Northwind<br>use Northwind<br>go<\/p>\n\n\n\n<p><strong>Los indices de la tabla Categories, primero obtenemos el object_id de la tabla<\/strong><br>select T.object_id from sys.tables As T where name = &#8216;Categories&#8217;<br>go<br>&#8212; El Object_id es 309576141<\/p>\n\n\n\n<p><strong>Listar los \u00edndices de una tabla teniendo el valor del object_id de la misma<\/strong><br>select * from sys.indexes where object_id = &#8216;309576141&#8217;<br>go<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"http:\/\/www.manualsqlserver.com\/wp-content\/uploads\/2017\/05\/ManualSQL_AlterIndex01.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_AlterIndex01.png\" alt=\"\" class=\"wp-image-1267\" width=\"712\" height=\"105\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_AlterIndex01.png 623w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_AlterIndex01-300x44.png 300w\" sizes=\"auto, (max-width: 712px) 100vw, 712px\" \/><\/a><\/figure><\/div>\n\n\n\n<p><strong>&#8212; Reconstruir el \u00edndice CategoriaNombreIDX<\/strong><br>Alter index CategoriaNombreIDX on Categories Rebuild<br>go<\/p>\n\n\n\n<p><strong>&#8212; Reconstruir PK_Categories asignando un factor de relleno de 70<\/strong><br>Alter index PK_Categories on Categories Rebuild with (fillfactor = 70)<br>go<\/p>\n\n\n\n<p><strong>&#8212; Reconstruir todos los \u00edndices de Products<\/strong><br>Alter index All on Products Rebuild<br>go<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Modificar un \u00edndice Reindexar o reconstruir un \u00edndice es una operaci\u00f3n que se sugiere para planes de mantenimiento, esto reordena los registros y permite en ocasiones optimizar las consultas.<\/p><p><a class=\"more-link btn\" href=\"https:\/\/manualsqlserver.com\/?p=161\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":1268,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[53],"class_list":["post-161","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-indices","tag-sqlserver","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=161"}],"version-history":[{"count":1,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/161\/revisions"}],"predecessor-version":[{"id":1269,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/161\/revisions\/1269"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/1268"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}