Este tipo de \u00edndice se diferencia de un \u00edndice regular en que permite b\u00fasquedas muy r\u00e1pidas de colecciones enteras de texto. Dichos \u00edndices almacenan cada palabra en un \u00edndice especial que se puede buscar usando el lenguaje natural. De manera similar a cuando se utiliza un motor de b\u00fasqueda.<\/p>\n\n\n\n
Estos tipos de \u00edndices s\u00f3lo se pueden utilizar en columnas de tipo CHAR,<\/em> VARCHAR<\/em><\/strong> y TEXT,<\/em><\/strong> y se pueden incluir a la hora de crear una tabla, o a\u00f1adirlo despu\u00e9s utilizando el comando ALTER TABLE<\/em><\/strong>.<\/p>\n\n\n\n Si tenemos grandes cantidades de datos y vamos a incluir un \u00edndice FULLTEXT<\/em><\/strong> en una tabla que subamos, la carga va a ser m\u00e1s lenta, por lo que lo recomendable en este caso es que lo subamos a una tabla que no tenga este \u00edndice, y despu\u00e9s de haber cargado los datos, agregarle el \u00edndice FULLTEXT.<\/em><\/strong><\/p>\n\n\n\n Siguiendo el ejm de cap\u00edtulos anteriores, vamos a incluir un \u00edndice FULLTEXT a nuestra tabla contactos,<\/em><\/strong> la sintaxis ser\u00eda la siguiente.<\/p>\n\n\n\n Ejm<\/strong><\/p>\n\n\n\n Este tipo de \u00edndices se suelen utilizar en registros con grandes cantidades de datos.<\/p>\n\n\n\n La sintaxis ser\u00eda la siguiente.<\/p>\n\n\n\n Ejm<\/strong><\/p>\n\n\n\n Este tipo de \u00edndice se diferencia de un \u00edndice regular en que permite b\u00fasquedas muy r\u00e1pidas de colecciones enteras de texto. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":4518,"menu_order":39,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-5316","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Sutil Web","author_link":"https:\/\/sutilweb.eu\/index.php\/author\/sutilweb\/"},"uagb_comment_info":0,"uagb_excerpt":"Este tipo de \u00edndice se diferencia de un \u00edndice regular en que permite b\u00fasquedas muy r\u00e1pidas de colecciones enteras de texto. […]","_links":{"self":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/5316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/comments?post=5316"}],"version-history":[{"count":3,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/5316\/revisions"}],"predecessor-version":[{"id":5319,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/5316\/revisions\/5319"}],"up":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/4518"}],"wp:attachment":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/media?parent=5316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}ALTER TABLE ejemplo.contactos ADD FULLTEXT(direccion);<\/code><\/pre>\n\n\n\n\u00cdndice FULLTEXT a la hora de crear una tabla<\/h2>\n\n\n\n
CREATE TABLE ejemplo.contactos (\nid INT NOT NULL AUTO_INCREMENT,\nnombre VARCHAR(64) NOT NULL,\napellidos VARCHAR(64) NOT NULL,\ndireccion VARCHAR(255) NOT NULL,\nfecha_nacimiento DATE DEFAULT NULL,\ntlfo VARCHAR(9) NOT NULL,\nfamilia TINYINT,\nPRIMARY KEY(id),\nINDEX (nombre),\nINDEX (apellidos),\nFULLTEXT(direccion)\n);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"