{"id":32227,"date":"2025-02-25T17:29:58","date_gmt":"2025-02-25T16:29:58","guid":{"rendered":"https:\/\/www.codemotion.com\/magazine\/?p=32227"},"modified":"2025-02-25T17:30:00","modified_gmt":"2025-02-25T16:30:00","slug":"introduccion-a-los-indices-en-sql-server-indices-parte-1","status":"publish","type":"post","link":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/","title":{"rendered":"Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1)"},"content":{"rendered":"\n<p><span style=\"font-weight: 400\">Vamos a empezar con una serie de varios art\u00edculos sobre los \u00edndices en SQL Server, un aspecto fundamental en nuestra base de datos que marcar\u00e1 todo su funcionamiento. A lo largo de los pr\u00f3ximos d\u00edas vamos a profundizar en este tema partiendo desde lo m\u00e1s b\u00e1sico. Empezaremos viendo las estructuras fundamentales de las tablas, lo que nos llevar\u00e1 a adentrarnos en los principales tipos de \u00edndices. Esos conocimientos nos ayudar\u00e1n a entender el resto de \u00edndices y c\u00f3mo afectan al rendimiento de nuestra base de datos. La mejor parte es que al final de la serie habremos aprendido c\u00f3mo mejorar y optimizar nuestros \u00edndices y por tanto, las consultas que leen datos de esas tablas.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-estructura-de-una-tabla-en-sql-server\"><span style=\"font-weight: 400\">Estructura de una tabla en SQL Server<\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">Como a estas alturas ya sabr\u00e9is, en SQL Server los datos se almacenan en tablas con columnas y filas. Lo que ya no todo el mundo sabe es que estas tablas a su vez se almacenan en p\u00e1ginas de 8 kb. Cada una de estas p\u00e1ginas es una unidad indivisible, son los \u00e1tomos de nuestra base de datos. Todas nuestras tablas tendr\u00e1n al menos una p\u00e1gina y ser\u00e1 exclusiva. Esto es importante, cada p\u00e1gina s\u00f3lo contendr\u00e1 datos de un solo objeto (tabla o \u00edndice). A medida que nuestras tablas crezcan ir\u00e1n ocupando m\u00e1s y m\u00e1s p\u00e1ginas pero siempre con estos requisitos que hemos comentado. Cuando se borren datos ese espacio se quedar\u00e1 libre pero no se liberar\u00e1, estar\u00e1 reservado para almacenar futuros datos de esa tabla.&nbsp;<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">La tabla m\u00e1s b\u00e1sica que podemos crear se llama HEAP (mont\u00f3n traducido literalmente). Ser\u00e1 una tabla donde los datos que escribimos se van a\u00f1adiendo en el primer espacio libre que encuentre en las p\u00e1ginas sin ning\u00fan orden. Empezar\u00e1 llenando secuencialmente el espacio de las p\u00e1ginas pero cuando quede espacio libre por alg\u00fan borrado se a\u00f1adir\u00e1 ah\u00ed.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-indices-clustered-en-sql-server\"><span style=\"font-weight: 400\">\u00cdndices Clustered en SQL Server<\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">Lo contrario a una tabla HEAP es una tabla con un \u00edndice clustered (agrupado). Los datos se escribir\u00e1n en p\u00e1ginas, ordenados siempre por la columna (o las columnas) del \u00edndice clustered. Como si de un diccionario se tratase, SQL Server sabe cual es el primer y el \u00faltimo dato de cada p\u00e1gina, lo que facilita en gran medida las b\u00fasquedas por estas columnas. Como se trata de la propia ordenaci\u00f3n de los datos s\u00f3lo puede haber un \u00edndice clustered por cada tabla.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-indices-nonclustered-en-sql-server\"><span style=\"font-weight: 400\">\u00cdndices Nonclustered en SQL Server<\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">Los \u00edndices nonclustered (no agrupados) son un objeto separado de la tabla, s\u00f3lo incluyen algunas de las columnas y se almacenan en p\u00e1ginas separadas. Un \u00edndice nonclustered ser\u00e1 por tanto una copia de la tabla original con solo parte de las columnas y ordenado de manera diferente. Tenga una tabla un \u00edndice clustered o sea un HEAP podremos crear tantos \u00edndices nonclustered como queramos.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-como-lee-los-datos-sql-server\"><span style=\"font-weight: 400\">\u00bfC\u00f3mo lee los datos SQL Server?<\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">Con lo que ya sabemos nos podemos hacer una idea de como SQL Server va a acceder a la informaci\u00f3n que tenemos almacenada y empezar a comprender la importancia de los \u00edndices. Vamos a empezar con una tabla HEAP como la que bajo estas l\u00edneas (pod\u00e9is ampliar la imagen haciendo click en ella):&nbsp;<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0c6e335a444&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0c6e335a444\" class=\"aligncenter size-medium 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--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.soydba.es\/wp-content\/uploads\/2023\/12\/heap-300x198.png\" alt=\"Heap\" class=\"wp-image-172\" \/><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--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><\/figure>\n<\/div>\n\n\n<p><span style=\"font-weight: 400\">Como veis tenemos una tabla de personas con un ID, nombre, apellido y una fecha de modificaci\u00f3n. Supongamos que tenemos que buscar la fecha de modificaci\u00f3n del usuario n\u00famero 2, \u00bfc\u00f3mo lo har\u00edais vosotros?. Pensadlo un momento. Si hab\u00e9is pensado en empezar a leer la columna id hasta llegar al 2 y despu\u00e9s recorrer horizontalmente la tabla hasta la columna fecha de modificaci\u00f3n, felicidades hab\u00e9is pensado como SQL Server. Ahora bien, esta no parece la forma m\u00e1s efectiva de consultar informaci\u00f3n, \u00bfverdad?. \u00bfY si la tabla en vez de 20 tuviera 20.000 registros? \u00bfY 20.000.000? Lo mejor ser\u00e1 crear un \u00edndice clustered por el campo ID para as\u00ed tenerlo ordenado, \u00bfno cre\u00e9is?<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Como hemos comentado el \u00edndice clustered es la propia tabla ordenada por lo que tendremos todos los datos igual que en nuestra tabla HEAP pero ordenados por la columna ID en este caso.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0c6e335aae3&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0c6e335aae3\" class=\"aligncenter size-medium 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--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.soydba.es\/wp-content\/uploads\/2023\/12\/clustered-300x197.png\" alt=\"Indices clustered\" class=\"wp-image-171\" \/><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--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><\/figure>\n<\/div>\n\n\n<p><span style=\"font-weight: 400\">Ahora es mucho m\u00e1s f\u00e1cil buscar los datos de una persona si nos dan su ID, \u00bfa que si?. Pero, \u00bfqu\u00e9 pasar\u00eda si la pregunta ahora fuese por la fecha de modificaci\u00f3n de los usuarios que se llaman Gigi? Tendr\u00edamos el mismo problema que antes, deber\u00edamos recorrer la columna nombre hasta encontrar el que buscamos. Es incluso peor cuando estamos hablando de datos que no son \u00fanicos, aunque hayamos encontrado un Gigi puede ser que haya m\u00e1s, no lo sabremos hasta que no terminemos con toda la tabla. Es entonces el momento de crear un \u00edndice nonclustered por el nombre y el id para ayudarnos en esta tarea. Ve\u00e1moslo:<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0c6e335b0a8&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0c6e335b0a8\" class=\"aligncenter size-medium 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--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.soydba.es\/wp-content\/uploads\/2023\/12\/nonclustered-205x300.png\" alt=\"\u00cdndices nonclustered\" class=\"wp-image-173\" \/><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--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><\/figure>\n<\/div>\n\n\n<p><span style=\"font-weight: 400\">Ahora si, podemos consultar nuestro \u00edndice nonclustered hasta ver que Gigi es el ID 9 y que el siguiente registro ya tiene otro valor por lo que solo hay una persona que se llama as\u00ed. Usaremos nuestro \u00edndice nonclustered para encontrar el ID y luego en nuestro \u00edndice clustered iremos directamente al registro que necesitamos.&nbsp;<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Si en este punto pens\u00e1is que os lleva m\u00e1s trabajo mirar primero el \u00edndice nonclustered y despu\u00e9s el clustered que directamente leer todo el \u00edndice clustered que solo tiene 20 registros no os preocupeis, SQL piensa igual. Los \u00edndices no se usan en tablas peque\u00f1as, aunque existan. En esos casos siempre va a tardar menos en leer la tabla entera que en usar los \u00edndices. Pero esto lo veremos m\u00e1s adelante, queda mucha serie de \u00edndices, veremos cosas nuevas y profundizaremos en lo que hemos visto. Estad atentos.&nbsp;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vamos a empezar con una serie de varios art\u00edculos sobre los \u00edndices en SQL Server, un aspecto fundamental en nuestra base de datos que marcar\u00e1 todo su funcionamiento. A lo largo de los pr\u00f3ximos d\u00edas vamos a profundizar en este tema partiendo desde lo m\u00e1s b\u00e1sico. Empezaremos viendo las estructuras fundamentales de las tablas, lo&#8230; <a class=\"more-link\" href=\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/\">Read more<\/a><\/p>\n","protected":false},"author":321,"featured_media":32265,"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-32227","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 v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1) - Codemotion Magazine<\/title>\n<meta name=\"description\" content=\"Descubre c\u00f3mo los \u00edndices en SQL Server afectan el rendimiento de tu base de datos. En esta serie de art\u00edculos, aprender\u00e1s desde lo b\u00e1sico hasta la optimizaci\u00f3n para mejorar tus consultas. \ud83d\ude80\" \/>\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\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1)\" \/>\n<meta property=\"og:description\" content=\"Descubre c\u00f3mo los \u00edndices en SQL Server afectan el rendimiento de tu base de datos. En esta serie de art\u00edculos, aprender\u00e1s desde lo b\u00e1sico hasta la optimizaci\u00f3n para mejorar tus consultas. \ud83d\ude80\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/\" \/>\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-02-25T16:29:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-25T16:30:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1792\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\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=\"5 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\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/\"},\"author\":{\"name\":\"Roberto Carrancio\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#\\\/schema\\\/person\\\/97a034bd0d0536df0240ef899434fa19\"},\"headline\":\"Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1)\",\"datePublished\":\"2025-02-25T16:29:58+00:00\",\"dateModified\":\"2025-02-25T16:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/\"},\"wordCount\":987,\"publisher\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp\",\"articleSection\":[\"Backend\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/\",\"name\":\"Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1) - Codemotion Magazine\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp\",\"datePublished\":\"2025-02-25T16:29:58+00:00\",\"dateModified\":\"2025-02-25T16:30:00+00:00\",\"description\":\"Descubre c\u00f3mo los \u00edndices en SQL Server afectan el rendimiento de tu base de datos. En esta serie de art\u00edculos, aprender\u00e1s desde lo b\u00e1sico hasta la optimizaci\u00f3n para mejorar tus consultas. \ud83d\ude80\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp\",\"contentUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp\",\"width\":1792,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/backend-es\\\/introduccion-a-los-indices-en-sql-server-indices-parte-1\\\/#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\":\"Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1)\"}]},{\"@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\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/2-100x100.png\",\"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":"Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1) - Codemotion Magazine","description":"Descubre c\u00f3mo los \u00edndices en SQL Server afectan el rendimiento de tu base de datos. En esta serie de art\u00edculos, aprender\u00e1s desde lo b\u00e1sico hasta la optimizaci\u00f3n para mejorar tus consultas. \ud83d\ude80","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\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/","og_locale":"en_US","og_type":"article","og_title":"Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1)","og_description":"Descubre c\u00f3mo los \u00edndices en SQL Server afectan el rendimiento de tu base de datos. En esta serie de art\u00edculos, aprender\u00e1s desde lo b\u00e1sico hasta la optimizaci\u00f3n para mejorar tus consultas. \ud83d\ude80","og_url":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/","og_site_name":"Codemotion Magazine","article_publisher":"https:\/\/www.facebook.com\/Codemotion.Italy\/","article_published_time":"2025-02-25T16:29:58+00:00","article_modified_time":"2025-02-25T16:30:00+00:00","og_image":[{"width":1792,"height":1024,"url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp","type":"image\/webp"}],"author":"Roberto Carrancio","twitter_card":"summary_large_image","twitter_creator":"@soy_dba","twitter_site":"@CodemotionIT","twitter_misc":{"Written by":"Roberto Carrancio","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/#article","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/"},"author":{"name":"Roberto Carrancio","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/97a034bd0d0536df0240ef899434fa19"},"headline":"Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1)","datePublished":"2025-02-25T16:29:58+00:00","dateModified":"2025-02-25T16:30:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/"},"wordCount":987,"publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp","articleSection":["Backend"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/","url":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/","name":"Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1) - Codemotion Magazine","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/#primaryimage"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp","datePublished":"2025-02-25T16:29:58+00:00","dateModified":"2025-02-25T16:30:00+00:00","description":"Descubre c\u00f3mo los \u00edndices en SQL Server afectan el rendimiento de tu base de datos. En esta serie de art\u00edculos, aprender\u00e1s desde lo b\u00e1sico hasta la optimizaci\u00f3n para mejorar tus consultas. \ud83d\ude80","breadcrumb":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/#primaryimage","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp","width":1792,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/www.codemotion.com\/magazine\/es\/backend-es\/introduccion-a-los-indices-en-sql-server-indices-parte-1\/#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":"Introducci\u00f3n a los \u00edndices en SQL Server (\u00cdndices parte 1)"}]},{"@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\/wp-content\/uploads\/2025\/06\/2-100x100.png","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\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-600x400.webp","featured_image_src_square":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-600x600.webp","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\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp",1792,1024,false],"thumbnail":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-150x150.webp",150,150,true],"medium":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-300x171.webp",300,171,true],"medium_large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-768x439.webp",768,439,true],"large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-1024x585.webp",1024,585,true],"1536x1536":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-1536x878.webp",1536,878,true],"2048x2048":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w.webp",1792,1024,false],"small-home-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-100x100.webp",100,100,true],"sidebar-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-180x128.webp",180,128,true],"genesis-singular-images":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-896x504.webp",896,504,true],"archive-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-400x225.webp",400,225,true],"gb-block-post-grid-landscape":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-600x400.webp",600,400,true],"gb-block-post-grid-square":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2025\/02\/DALL\u00b7E-2025-02-25-17.29.01-A-modern-and-visually-appealing-digital-illustration-of-a-SQL-Server-database-with-indexing-concepts.-The-image-features-a-structured-database-table-w-600x600.webp",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":"Vamos a empezar con una serie de varios art\u00edculos sobre los \u00edndices en SQL Server, un aspecto fundamental en nuestra base de datos que marcar\u00e1 todo su funcionamiento. A lo largo de los pr\u00f3ximos d\u00edas vamos a profundizar en este tema partiendo desde lo m\u00e1s b\u00e1sico. Empezaremos viendo las estructuras fundamentales de las tablas, lo&#8230;&hellip;","lang":"es","_links":{"self":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/32227","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=32227"}],"version-history":[{"count":1,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/32227\/revisions"}],"predecessor-version":[{"id":32230,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/32227\/revisions\/32230"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media\/32265"}],"wp:attachment":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media?parent=32227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/categories?post=32227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/tags?post=32227"},{"taxonomy":"collections","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/collections?post=32227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}