{"id":165,"date":"2017-09-18T21:20:00","date_gmt":"2017-09-18T21:20:00","guid":{"rendered":"http:\/\/www.manualsqlserver.com\/?p=165"},"modified":"2020-05-20T04:13:06","modified_gmt":"2020-05-20T04:13:06","slug":"indices-eliminacion","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=165","title":{"rendered":"\u00cdndices SQL Server &#8211; Eliminaci\u00f3n"},"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_DropIndexD.png\" alt=\"\" class=\"wp-image-1277\" width=\"256\" height=\"262\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_DropIndexD.png 300w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_DropIndexD-293x300.png 293w\" sizes=\"auto, (max-width: 256px) 100vw, 256px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Eliminando un \u00edndice en SQL Server<\/strong><\/h1>\n\n\n\n<p>La instrucci\u00f3n Drop Index permite eliminar los \u00edndices de una tabla o vista. La eliminaci\u00f3n de un \u00edndice tiene que ser decidida con cuidado, si el \u00edndice permit\u00eda que alguna consulta sea m\u00e1s \u00f3ptima, eliminarlo podr\u00eda causar que las consultas y reportes en los sistemas sean m\u00e1s lentos.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h3 class=\"wp-block-heading\">Sintaxis<\/h3>\n\n\n\n<p><strong>Drop index NombreIndice on Tabla\/Vista<\/strong><\/p>\n\n\n\n<p><strong>Eliminar el \u00edndice CategoriaNombreIDX de la tabla Categories<\/strong><br>Drop index CategoriaNombreIDX on Categories<br>go<\/p>\n\n\n\n<p><strong>Eliminar varios \u00edndices<\/strong><br>Drop index CompanyName on Customers,<br>EmpleadosNombreCompletoIDX on Employees<br>go<\/p>\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<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Eliminando un \u00edndice en SQL Server La instrucci\u00f3n Drop Index permite eliminar los \u00edndices de una tabla o vista. La eliminaci\u00f3n de un \u00edndice tiene que ser decidida con cuidado, si el \u00edndice permit\u00eda que alguna consulta sea m\u00e1s \u00f3ptima, eliminarlo podr\u00eda causar que las consultas y reportes en los sistemas sean m\u00e1s lentos.<\/p><p><a class=\"more-link btn\" href=\"https:\/\/manualsqlserver.com\/?p=165\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":1277,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[53],"class_list":["post-165","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\/165","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=165"}],"version-history":[{"count":1,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/165\/revisions"}],"predecessor-version":[{"id":1278,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/165\/revisions\/1278"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/1277"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}