{"id":32400,"date":"2025-05-26T15:47:09","date_gmt":"2025-05-26T13:47:09","guid":{"rendered":"https:\/\/www.codemotion.com\/magazine\/?p=32400"},"modified":"2025-05-26T15:47:11","modified_gmt":"2025-05-26T13:47:11","slug":"indices-especiales-en-sql-server","status":"publish","type":"post","link":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/","title":{"rendered":"\u00cdndices especiales en SQL Server"},"content":{"rendered":"\n<p><span style=\"font-weight: 400\">Sexta entrega de esta amplia serie sobre \u00edndices donde hemos podido aprender en profundidad todo sobre los principales \u00edndices de SQL Server. Antes de entrar en detalle sobre el uso y mantenimiento de los mismos vamos a terminar de repasar r\u00e1pidamente los tipos de \u00edndices especiales.Estos \u00edndices especiales son, en su mayor\u00eda, espec\u00edficos para casos concretos de uso y, si bien su uso est\u00e1 mucho menos extendido, como DBAs tenemos que conocer.&nbsp;<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-indices-especiales-para-funcionalidades-comunes-en-sql-server\"><span style=\"font-weight: 400\">\u00cdndices especiales para funcionalidades comunes en SQL Server<\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">Este tipo de \u00edndices est\u00e1n pensado para ampliar la funcionalidad de los \u00edndices existentes y que hemos repasado en anteriores entradas de esta serie. Hablamos de los \u00edndices \u00fanicos y los \u00edndices filtrados y podr\u00edamos decir que existen para complementar al resto de \u00edndices.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-indices-unicos\"><span style=\"font-weight: 400\">\u00cdndices \u00fanicos<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">La unicidad en una columna es una restricci\u00f3n que se utiliza para mantener la integridad de los datos. Como ya vimos cuando hablamos de las PK, una restricci\u00f3n es una medida l\u00f3gica que necesita reforzarse con un \u00edndice f\u00edsico. Siempre que queramos crear una restricci\u00f3n de unicidad se crear\u00e1 por defecto un \u00edndice nonclustered sobre esa(s) columna(s). Tambi\u00e9n podremos a\u00f1adir la cl\u00e1usula UNIQUE al crear un \u00edndice clustered o nonclustered.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">A la hora de borrarlos, tenemos que tener en cuenta que si la restricci\u00f3n de unicidad se ha creado como restricci\u00f3n (constraint). Si el \u00edndice se ha creado autom\u00e1ticamente para reforzar una constraint no podremos usar la sintaxis DROP INDEX y deberemos usar DROP CONSTRAINT. Si hemos creado un \u00edndice con la cl\u00e1usula UNIQUE s\u00ed que deberemos usar DROP INDEX.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-indices-filtrados\"><span style=\"font-weight: 400\">\u00cdndices Filtrados<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">En ocasiones creamos un \u00edndice para mejorar el rendimiento de unas consultas que siempre filtran por los mismos valores de una columna. En estos casos podremos agregar un predicado where a nuestros \u00edndices nonclustered (columnstore o \u00e1rbol B). Esto reducir\u00e1 el espacio que ocupa nuestro \u00edndice y mejorar\u00e1 su rendimiento.&nbsp;<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Tenemos que tener en cuenta que cuanto m\u00e1s l\u00f3gica a\u00f1adamos a nuestros \u00edndices m\u00e1s le costar\u00e1 a SQL Server mantenerlos. Si el conjunto de resultados resultantes de los filtros del \u00edndice, es similar al total de la tabla seguramente no ser\u00e1 rentable mantenerlo y deberemos crear un \u00edndice de tabla-completa.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-indices-especiales-para-columnas-especiales-en-sql-server\"><span style=\"font-weight: 400\">\u00cdndices especiales para columnas especiales en SQL Server<\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">A lo largo de las distintas versiones de SQL se ha ido a\u00f1adiendo soporte para informaci\u00f3n especial. Estos \u00edndices que vamos a ver a continuaci\u00f3n est\u00e1n pensados para dar soporte a este tipo de informaci\u00f3n especial.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-indices-espaciales\"><span style=\"font-weight: 400\">\u00cdndices espaciales<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">A partir de SQL Server 2008 se introdujeron las columnas GEOGRAPHY y GEOMETRY, para guardar informaci\u00f3n de coordenadas o geom\u00e9trica de puntos, l\u00edneas y pol\u00edgonos respectivamente. Estos tipos de datos se conocen como datos espaciales y para ellos se crearon estos tipos de \u00edndices.&nbsp;<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Estos \u00edndices solo se pueden crear en tablas que tengan PK y en columnas espaciales.&nbsp;<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;69e4f739b6fc2&quot;}\" data-wp-interactive=\"core\/image\" class=\"aligncenter size-thumbnail wp-lightbox-container\"><img decoding=\"async\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on-async--click=\"actions.showLightbox\" data-wp-on-async--load=\"callbacks.setButtonStyles\" data-wp-on-async-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.soydba.es\/wp-content\/uploads\/2023\/12\/imagen_2023-12-18_134112425-150x150.png\" alt=\"\u00cdndices especiales\" class=\"wp-image-276\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on-async--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><figcaption class=\"wp-element-caption\">\u00cdndices especiales<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-indices-xml\"><span style=\"font-weight: 400\">\u00cdndices XML<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Como su propio nombre indica los \u00edndices XML son \u00edndices especiales para columnas de tipo XML en tablas que tengan PK. A poco que conozc\u00e1is el est\u00e1ndar XML entender\u00e9is que estas columnas normalmente almacenan grandes cantidades de informaci\u00f3n de distintos tipos agrupadas en categor\u00edas.&nbsp;<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Existen dos tipos de \u00edndices XML, los primarios y los secundarios. Crearemos un \u00edndice XML primario para indexar las columnas XML. Despu\u00e9s de crear el \u00edndice primario podremos crear \u00edndices XML secundarios para etiquetas concretas dentro de esa columna.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-indices-especiales-para-caracteristicas-especiales-de-sql-server\"><span style=\"font-weight: 400\">\u00cdndices especiales para caracter\u00edsticas especiales de SQL Server<\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">Igual que nos ha pasado en el apartado anterior, SQL ha ido implementando nuevas caracter\u00edsticas para las que ha implementado los \u00edndices concretos que vamos a ver ahora.&nbsp;<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-indices-hash\"><span style=\"font-weight: 400\">\u00cdndices hash<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Son un tipo de \u00edndice especial para tablas optimizadas para memoria. Todas las tablas optimizadas para memoria requieren de un \u00edndice de este tipo o un \u00edndice nonclustered optimizado para memoria. Sin entrar mucho m\u00e1s en detalle, tenemos que saber que son un tipo de \u00edndice que almacena hash de la informaci\u00f3n ocupando una cantidad de memoria fija.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-indices-de-texto-completo\"><span style=\"font-weight: 400\">\u00cdndices de texto completo<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Este tipo de \u00edndices son creados, usados y mantenidos por el motor de SQL Full-text. Permiten a las consultas Full-Text localizar cadenas de texto, para ello dividen las columnas en tokens que luego almacenan en el \u00edndice.&nbsp;<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\"><span style=\"font-weight: 400\">Conclusi\u00f3n<\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">Concluimos con esta sexta entrega el repaso a los distintos tipos de \u00edndices que nos podemos encontrar en SQL Server. Hoy hemos aprendido cu\u00e1les son los \u00edndices especiales que se adaptar\u00e1n a casu\u00edsticas concretas de nuestras instalaciones. <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sexta entrega de esta amplia serie sobre \u00edndices donde hemos podido aprender en profundidad todo sobre los principales \u00edndices de SQL Server. Antes de entrar en detalle sobre el uso y mantenimiento de los mismos vamos a terminar de repasar r\u00e1pidamente los tipos de \u00edndices especiales.Estos \u00edndices especiales son, en su mayor\u00eda, espec\u00edficos para casos&#8230; <a class=\"more-link\" href=\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/\">Read more<\/a><\/p>\n","protected":false},"author":321,"featured_media":33191,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","_uag_custom_page_level_css":"","_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[10606],"tags":[],"collections":[13134,13126,13130,13132,13139,13136,13128],"class_list":{"0":"post-32400","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-backend-es","8":"collections-bases-de-datos","9":"collections-databases","10":"collections-indexes","11":"collections-indices","12":"collections-rendimiento","13":"collections-sql","14":"collections-sql-server","15":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v26.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>\u00cdndices especiales en SQL Server - Codemotion Magazine<\/title>\n<meta name=\"description\" content=\"En esta sexta entrega de la serie sobre \u00edndices en SQL Server, repasamos los tipos de \u00edndices especiales. Aunque son menos comunes, conocer su utilidad es clave para DBAs que buscan optimizar casos de uso espec\u00edficos antes de adentrarse en su mantenimiento.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00cdndices especiales en SQL Server\" \/>\n<meta property=\"og:description\" content=\"En esta sexta entrega de la serie sobre \u00edndices en SQL Server, repasamos los tipos de \u00edndices especiales. Aunque son menos comunes, conocer su utilidad es clave para DBAs que buscan optimizar casos de uso espec\u00edficos antes de adentrarse en su mantenimiento.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Codemotion Magazine\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Codemotion.Italy\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-26T13:47:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-26T13:47:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Roberto Carrancio\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@soy_dba\" \/>\n<meta name=\"twitter:site\" content=\"@CodemotionIT\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Roberto Carrancio\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/\"},\"author\":{\"name\":\"Roberto Carrancio\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/97a034bd0d0536df0240ef899434fa19\"},\"headline\":\"\u00cdndices especiales en SQL Server\",\"datePublished\":\"2025-05-26T13:47:09+00:00\",\"dateModified\":\"2025-05-26T13:47:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/\"},\"wordCount\":783,\"publisher\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg\",\"articleSection\":[\"Backend\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/\",\"name\":\"\u00cdndices especiales en SQL Server - Codemotion Magazine\",\"isPartOf\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg\",\"datePublished\":\"2025-05-26T13:47:09+00:00\",\"dateModified\":\"2025-05-26T13:47:11+00:00\",\"description\":\"En esta sexta entrega de la serie sobre \u00edndices en SQL Server, repasamos los tipos de \u00edndices especiales. Aunque son menos comunes, conocer su utilidad es clave para DBAs que buscan optimizar casos de uso espec\u00edficos antes de adentrarse en su mantenimiento.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#primaryimage\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg\",\"contentUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg\",\"width\":2560,\"height\":1707,\"caption\":\"ai ready frontend\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.codemotion.com\/magazine\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backend\",\"item\":\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u00cdndices especiales en SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#website\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/\",\"name\":\"Codemotion Magazine\",\"description\":\"We code the future. Together\",\"publisher\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.codemotion.com\/magazine\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#organization\",\"name\":\"Codemotion\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png\",\"contentUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png\",\"width\":225,\"height\":225,\"caption\":\"Codemotion\"},\"image\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Codemotion.Italy\/\",\"https:\/\/x.com\/CodemotionIT\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/97a034bd0d0536df0240ef899434fa19\",\"name\":\"Roberto Carrancio\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/06\/2-100x100.png\",\"contentUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/06\/2-100x100.png\",\"caption\":\"Roberto Carrancio\"},\"description\":\"Mi nombre es Roberto Carrancio y soy un DBA de SQL server con m\u00e1s de 12 a\u00f1os de experiencia en el sector. Recientemente he sido reconocido como Microsoft MVP en la categor\u00eda Data Platform en SQL Server y en Azure SQL. Durante mis a\u00f1os de experiencia he tenido oportunidad de lidiar con proyectos en compa\u00f1\u00edas de todos los tama\u00f1os y sectores, desde pymes hasta grandes multinacionales. Tambi\u00e9n soy el creador del blog soydba.es donde intento publicar varios art\u00edculos a la semana.\",\"sameAs\":[\"https:\/\/www.soydba.es\",\"https:\/\/www.linkedin.com\/in\/robertocarrancio\/\",\"https:\/\/x.com\/soy_dba\",\"https:\/\/www.youtube.com\/@SoyDBA\"],\"url\":\"https:\/\/www.codemotion.com\/magazine\/author\/rocarrancio\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u00cdndices especiales en SQL Server - Codemotion Magazine","description":"En esta sexta entrega de la serie sobre \u00edndices en SQL Server, repasamos los tipos de \u00edndices especiales. Aunque son menos comunes, conocer su utilidad es clave para DBAs que buscan optimizar casos de uso espec\u00edficos antes de adentrarse en su mantenimiento.","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:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"\u00cdndices especiales en SQL Server","og_description":"En esta sexta entrega de la serie sobre \u00edndices en SQL Server, repasamos los tipos de \u00edndices especiales. Aunque son menos comunes, conocer su utilidad es clave para DBAs que buscan optimizar casos de uso espec\u00edficos antes de adentrarse en su mantenimiento.","og_url":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/","og_site_name":"Codemotion Magazine","article_publisher":"https:\/\/www.facebook.com\/Codemotion.Italy\/","article_published_time":"2025-05-26T13:47:09+00:00","article_modified_time":"2025-05-26T13:47:11+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg","type":"image\/jpeg"}],"author":"Roberto Carrancio","twitter_card":"summary_large_image","twitter_creator":"@soy_dba","twitter_site":"@CodemotionIT","twitter_misc":{"Written by":"Roberto Carrancio","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/"},"author":{"name":"Roberto Carrancio","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/97a034bd0d0536df0240ef899434fa19"},"headline":"\u00cdndices especiales en SQL Server","datePublished":"2025-05-26T13:47:09+00:00","dateModified":"2025-05-26T13:47:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/"},"wordCount":783,"publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg","articleSection":["Backend"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/","url":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/","name":"\u00cdndices especiales en SQL Server - Codemotion Magazine","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg","datePublished":"2025-05-26T13:47:09+00:00","dateModified":"2025-05-26T13:47:11+00:00","description":"En esta sexta entrega de la serie sobre \u00edndices en SQL Server, repasamos los tipos de \u00edndices especiales. Aunque son menos comunes, conocer su utilidad es clave para DBAs que buscan optimizar casos de uso espec\u00edficos antes de adentrarse en su mantenimiento.","breadcrumb":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#primaryimage","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg","width":2560,"height":1707,"caption":"ai ready frontend"},{"@type":"BreadcrumbList","@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/indices-especiales-en-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.codemotion.com\/magazine\/"},{"@type":"ListItem","position":2,"name":"Backend","item":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/"},{"@type":"ListItem","position":3,"name":"\u00cdndices especiales en SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.codemotion.com\/magazine\/#website","url":"https:\/\/www.codemotion.com\/magazine\/","name":"Codemotion Magazine","description":"We code the future. Together","publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.codemotion.com\/magazine\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.codemotion.com\/magazine\/#organization","name":"Codemotion","url":"https:\/\/www.codemotion.com\/magazine\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png","width":225,"height":225,"caption":"Codemotion"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Codemotion.Italy\/","https:\/\/x.com\/CodemotionIT"]},{"@type":"Person","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/97a034bd0d0536df0240ef899434fa19","name":"Roberto Carrancio","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/image\/","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/06\/2-100x100.png","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/06\/2-100x100.png","caption":"Roberto Carrancio"},"description":"Mi nombre es Roberto Carrancio y soy un DBA de SQL server con m\u00e1s de 12 a\u00f1os de experiencia en el sector. Recientemente he sido reconocido como Microsoft MVP en la categor\u00eda Data Platform en SQL Server y en Azure SQL. Durante mis a\u00f1os de experiencia he tenido oportunidad de lidiar con proyectos en compa\u00f1\u00edas de todos los tama\u00f1os y sectores, desde pymes hasta grandes multinacionales. Tambi\u00e9n soy el creador del blog soydba.es donde intento publicar varios art\u00edculos a la semana.","sameAs":["https:\/\/www.soydba.es","https:\/\/www.linkedin.com\/in\/robertocarrancio\/","https:\/\/x.com\/soy_dba","https:\/\/www.youtube.com\/@SoyDBA"],"url":"https:\/\/www.codemotion.com\/magazine\/author\/rocarrancio\/"}]}},"featured_image_src":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-600x400.jpg","featured_image_src_square":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-600x600.jpg","author_info":{"display_name":"Roberto Carrancio","author_link":"https:\/\/www.codemotion.com\/magazine\/author\/rocarrancio\/"},"uagb_featured_image_src":{"full":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-scaled.jpg",2560,1707,false],"thumbnail":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-150x150.jpg",150,150,true],"medium":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-300x200.jpg",300,200,true],"medium_large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-768x512.jpg",768,512,true],"large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-1024x683.jpg",1024,683,true],"1536x1536":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-1536x1024.jpg",1536,1024,true],"2048x2048":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-2048x1365.jpg",2048,1365,true],"small-home-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-100x100.jpg",100,100,true],"sidebar-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-180x128.jpg",180,128,true],"genesis-singular-images":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-896x504.jpg",896,504,true],"archive-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-400x225.jpg",400,225,true],"gb-block-post-grid-landscape":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-600x400.jpg",600,400,true],"gb-block-post-grid-square":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/03\/6597434-600x600.jpg",600,600,true]},"uagb_author_info":{"display_name":"Roberto Carrancio","author_link":"https:\/\/www.codemotion.com\/magazine\/author\/rocarrancio\/"},"uagb_comment_info":0,"uagb_excerpt":"Sexta entrega de esta amplia serie sobre \u00edndices donde hemos podido aprender en profundidad todo sobre los principales \u00edndices de SQL Server. Antes de entrar en detalle sobre el uso y mantenimiento de los mismos vamos a terminar de repasar r\u00e1pidamente los tipos de \u00edndices especiales.Estos \u00edndices especiales son, en su mayor\u00eda, espec\u00edficos para casos&#8230;&hellip;","lang":"es","_links":{"self":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/32400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/users\/321"}],"replies":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/comments?post=32400"}],"version-history":[{"count":2,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/32400\/revisions"}],"predecessor-version":[{"id":33193,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/32400\/revisions\/33193"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media\/33191"}],"wp:attachment":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media?parent=32400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/categories?post=32400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/tags?post=32400"},{"taxonomy":"collections","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/collections?post=32400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}