{"id":6134,"date":"2023-07-26T09:56:39","date_gmt":"2023-07-26T09:56:39","guid":{"rendered":"https:\/\/www.webhi.com\/how-to\/?p=6134"},"modified":"2023-07-26T09:56:47","modified_gmt":"2023-07-26T09:56:47","slug":"comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat","status":"publish","type":"post","link":"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/","title":{"rendered":"Comment utiliser les index dans MySQL"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/07\/mysql_index_fr.jpg\" alt=\"Index dans MySQL dans ubuntu centos Debian redhat\" class=\"wp-image-6153\" srcset=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/07\/mysql_index_fr.jpg 1200w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/07\/mysql_index_fr-300x169.jpg 300w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/07\/mysql_index_fr-1024x576.jpg 1024w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/07\/mysql_index_fr-768x432.jpg 768w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/07\/mysql_index_fr-150x84.jpg 150w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"introduction-aux-index\">Introduction aux index<\/h2>\n\n\n\n<p>Les index sont une partie importante de l&#8217;optimisation des bases de donn\u00e9es MySQL. Un index permet \u00e0 la base de donn\u00e9es de trouver et de r\u00e9cup\u00e9rer les donn\u00e9es des tables beaucoup plus rapidement en stockant une liste tri\u00e9e de valeurs qui pointent vers les enregistrements complets.<\/p>\n\n\n\n<p>Sans index, MySQL doit analyser chaque ligne d&#8217;une table pour trouver les donn\u00e9es pertinentes. Cela peut devenir tr\u00e8s lent \u00e0 mesure que les tables grossissent. L&#8217;ajout d&#8217;index appropri\u00e9s permet \u00e0 MySQL de naviguer dans les donn\u00e9es de la table de mani\u00e8re beaucoup plus efficace.<\/p>\n\n\n\n<p>Quelques avantages cl\u00e9s de l&#8217;utilisation d&#8217;index:<\/p>\n\n\n\n<ul>\n<li>Recherches plus rapides pour des lignes et des valeurs sp\u00e9cifiques<\/li>\n\n\n\n<li>Am\u00e9lioration des performances de diverses requ\u00eates, en particulier les JOINTURES et les clauses WHERE<\/li>\n\n\n\n<li>Capacit\u00e9 \u00e0 optimiser la r\u00e9cup\u00e9ration des donn\u00e9es sur de grandes tables de base de donn\u00e9es<\/li>\n\n\n\n<li>Tris et regroupements plus rapides sur les colonnes index\u00e9es<\/li>\n<\/ul>\n\n\n\n<p>MySQL prend en charge plusieurs types d&#8217;index pour am\u00e9liorer les requ\u00eates de diff\u00e9rentes mani\u00e8res:<\/p>\n\n\n\n<ul>\n<li>NORMAL &#8211; Index de base sur une ou plusieurs colonnes<\/li>\n\n\n\n<li>UNIQUE &#8211; Garantit l&#8217;unicit\u00e9 des valeurs index\u00e9es<\/li>\n\n\n\n<li>FULLTEXT &#8211; Pour optimiser les recherches bas\u00e9es sur du texte<\/li>\n\n\n\n<li>SPATIAL &#8211; Pour les donn\u00e9es spatiales comme les emplacements<\/li>\n<\/ul>\n\n\n\n<p>Ce guide fournira des exemples de cr\u00e9ation et d&#8217;utilisation de ces diff\u00e9rents types d&#8217;index MySQL pour am\u00e9liorer les performances de la base de donn\u00e9es.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"connexion-%C3%A0-mysql-et-configuration-dune-base-de-donn%C3%A9es-dexemple\">Connexion \u00e0 MySQL et configuration d&#8217;une base de donn\u00e9es d&#8217;exemple<\/h2>\n\n\n\n<p>Avant de d\u00e9montrer les index, nous avons besoin d&#8217;une base de donn\u00e9es MySQL avec quelques exemples de donn\u00e9es. Voici les \u00e9tapes pour se connecter \u00e0 MySQL et cr\u00e9er une simple base de donn\u00e9es \u00abcontacts\u00bb:<\/p>\n\n\n\n<ol>\n<li>Connectez-vous au serveur MySQL depuis la ligne de commande avec le client mysql:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -u root -p<\/code><\/pre>\n\n\n\n<ol start=\"2\">\n<li>Lorsque vous y \u00eates invit\u00e9, entrez le mot de passe de l&#8217;utilisateur root MySQL. Vous devriez maintenant \u00eatre au moniteur MySQL.<\/li>\n\n\n\n<li>Cr\u00e9ez une nouvelle base de donn\u00e9es appel\u00e9e&nbsp;<code>contacts<\/code>:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; CREATE DATABASE contacts;<\/code><\/pre>\n\n\n\n<ol start=\"4\">\n<li>Basculez vers la nouvelle base de donn\u00e9es contacts:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; USE contacts;<\/code><\/pre>\n\n\n\n<ol start=\"5\">\n<li>Cr\u00e9ez un tableau&nbsp;<code>contacts<\/code>&nbsp;avec quelques exemples de donn\u00e9es:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">mysql&gt; CREATE TABLE contacts (\n  id INT AUTO_INCREMENT PRIMARY KEY,\n  first_name VARCHAR(50),\n  last_name VARCHAR(50),\n  email VARCHAR(100),\n  phone VARCHAR(20)\n);\n\nmysql&gt; INSERT INTO contacts (first_name, last_name, email, phone)\nVALUES\n  ('John', 'Doe', 'john@example.com', '555-555-5555'),\n  ('Jane', 'Doe', 'jane@example.com', '555-555-5556'),\n  ('Bob', 'Smith', 'bob@example.com', '555-555-5557');<\/code><\/pre>\n\n\n\n<p>Cela cr\u00e9e une table simple pour stocker des informations de contact comme le nom, l&#8217;e-mail et le num\u00e9ro de t\u00e9l\u00e9phone.<\/p>\n\n\n\n<p>Nous pouvons confirmer que cela a fonctionn\u00e9 en interrogeant la table:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SELECT * FROM contacts;<\/code><\/pre>\n\n\n\n<p>Cela devrait afficher les exemples de donn\u00e9es que nous avons ins\u00e9r\u00e9s. Nous avons maintenant une base de donn\u00e9es et une table pr\u00eates \u00e0 d\u00e9montrer l&#8217;utilisation d&#8217;index.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">+----+------------+-----------+--------------------+---------------+\n| id | first_name | last_name | email              | phone         |\n+----+------------+-----------+--------------------+---------------+   \n|  1 | John       | Doe       | john@example.com   | 555-555-5555  |\n|  2 | Jane       | Doe       | jane@example.com   | 555-555-5556  |\n|  3 | Bob        | Smith     | bob@example.com    | 555-555-5557  |\n+----+------------+-----------+--------------------+---------------+\n3 lignes trouv\u00e9es (0.00 sec)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"utilisation-dindex-sur-une-seule-colonne\">Utilisation d&#8217;index sur une seule colonne<\/h2>\n\n\n\n<p>Un index standard dans MySQL indexe une colonne d&#8217;une table de base de donn\u00e9es. Cela permet des recherches et des tris rapides sur cette colonne particuli\u00e8re.<\/p>\n\n\n\n<p>Pour ajouter un index \u00e0 une colonne, nous pouvons utiliser l&#8217;instruction&nbsp;<code>CREATE INDEX<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; CREATE INDEX idx_last_name ON contacts(last_name);<\/code><\/pre>\n\n\n\n<p>Cela ajoute un index nomm\u00e9&nbsp;<code>idx_last_name<\/code>&nbsp;sur la colonne&nbsp;<code>last_name<\/code>&nbsp;du tableau&nbsp;<code>contacts<\/code>.<\/p>\n\n\n\n<p>L&#8217;indexation de la colonne last_name peut optimiser les requ\u00eates comme celle-ci qui filtrent par un nom de famille:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SELECT * FROM contacts WHERE last_name='Doe';<\/code><\/pre>\n\n\n\n<p>Au lieu d&#8217;analyser chaque ligne, MySQL peut rechercher rapidement la colonne last_name index\u00e9e pour trouver les lignes pertinentes.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">+----+------------+-----------+--------------------+---------------+\n| id | first_name | last_name | email              | phone         |\n+----+------------+-----------+--------------------+---------------+ \n|  1 | John       | Doe       | john@example.com   | 555-555-5555  |\n|  2 | Jane       | Doe       | jane@example.com   | 555-555-5556  |  \n+----+------------+-----------+--------------------+---------------+\n2 lignes trouv\u00e9es (0.00 sec)<\/code><\/pre>\n\n\n\n<p>Cela montre les lignes renvoy\u00e9es de la table contacts o\u00f9 le nom de famille est &#8216;Doe&#8217;. L&#8217;index sur la colonne last_name permet \u00e0 cette requ\u00eate de s&#8217;ex\u00e9cuter rapidement sans analyse de toute la table.<\/p>\n\n\n\n<p>Nous pouvons ajouter des index similaires sur d&#8217;autres colonnes de table comme email ou phone:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; CREATE INDEX idx_email ON contacts(email);\nmysql&gt; CREATE INDEX idx_phone ON contacts(phone);<\/code><\/pre>\n\n\n\n<p>Cela permet \u00e9galement des recherches rapides par ces colonnes.<\/p>\n\n\n\n<p>Pour supprimer un index lorsqu&#8217;il n&#8217;est plus n\u00e9cessaire, utilisez&nbsp;<code>DROP INDEX<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; DROP INDEX idx_email ON contacts;<\/code><\/pre>\n\n\n\n<p>Les index sur une seule colonne fonctionnent le mieux sur des colonnes fr\u00e9quemment utilis\u00e9es pour les recherches et les jointures. Ne sur-indexez pas toutes les colonnes, car les index occupent de l&#8217;espace de stockage et ralentissent les op\u00e9rations d&#8217;\u00e9criture comme INSERT et UPDATE car les index doivent \u00e9galement \u00eatre mis \u00e0 jour.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"utilisation-dindex-uniques-pour-%C3%A9viter-la-duplication-des-donn%C3%A9es\">Utilisation d&#8217;index uniques pour \u00e9viter la duplication des donn\u00e9es<\/h2>\n\n\n\n<p>Dans de nombreux cas, nous voulons emp\u00eacher la duplication de valeurs dans certaines colonnes, telles que les adresses e-mail ou les noms d&#8217;utilisateur. MySQL fournit un index UNIQUE sp\u00e9cial qui applique cette contrainte:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; CREATE UNIQUE INDEX idx_email ON contacts(email);<\/code><\/pre>\n\n\n\n<p>Cet index ne permet que des valeurs d&#8217;e-mail uniques \u00e0 ins\u00e9rer dans cette colonne. Si nous essayons d&#8217;ins\u00e9rer un e-mail en double:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; INSER TINTO contacts (first_name, last_name, email, phone)\nVALUES ('Bob', 'Jones', 'bob@example.com', '555-555-5558');<\/code><\/pre>\n\n\n\n<p>Nous obtiendrions une erreur:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">ERROR 1062 (23000): Duplicate entry 'bob@example.com' for key 'idx_email' <\/code><\/pre>\n\n\n\n<p>L&#8217;index unique a emp\u00each\u00e9 l&#8217;insertion de l&#8217;e-mail en double. Cela aide \u00e0 appliquer l&#8217;int\u00e9grit\u00e9 des donn\u00e9es dans les colonnes importantes.<\/p>\n\n\n\n<p>Comme les autres index, l&#8217;index UNIQUE fournit toujours des recherches rapides par colonne index\u00e9e. L&#8217;unicit\u00e9 est simplement une contrainte suppl\u00e9mentaire.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"utilisation-dindex-sur-plusieurs-colonnes\">Utilisation d&#8217;index sur plusieurs colonnes<\/h2>\n\n\n\n<p>Les index peuvent \u00e9galement \u00eatre cr\u00e9\u00e9s sur plusieurs colonnes. Cela permet d&#8217;optimiser les requ\u00eates qui filtrent sur ces colonnes dans le m\u00eame ordre.<\/p>\n\n\n\n<p>Par exemple, pour indexer les colonnes first_name et last_name:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; CREATE INDEX idx_name ON contacts(first_name, last_name); <\/code><\/pre>\n\n\n\n<p>Cela peut optimiser une requ\u00eate avec une clause WHERE sur les deux colonnes:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SELECT * FROM contacts WHERE first_name='Jane'AND last_name='Doe';<\/code><\/pre>\n\n\n\n<p>Cela fonctionne \u00e9galement pour les requ\u00eates ne filtrant que la premi\u00e8re colonne index\u00e9e:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SELECT * FROM contacts WHERE first_name='Jane';<\/code><\/pre>\n\n\n\n<p>Mais cela n&#8217;optimiserait pas une requ\u00eate ne filtrant que la deuxi\u00e8me colonne index\u00e9e:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SELECT * FROM contacts WHERE last_name='Doe';<\/code><\/pre>\n\n\n\n<p>Dans ce cas, l&#8217;index sur une seule colonne sur&nbsp;<code>last_name<\/code>&nbsp;serait utilis\u00e9 \u00e0 la place.<\/p>\n\n\n\n<p>L&#8217;ordre des colonnes dans un index sur plusieurs colonnes est important. Les optimisations s&#8217;appliquent aux clauses WHERE avec des filtres sur les pr\u00e9fixes des colonnes index\u00e9es.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"liste-et-suppression-des-index-existants\">Liste et suppression des index existants<\/h2>\n\n\n\n<p>Pour comprendre quels index existent sur une table, nous pouvons interroger la base de donn\u00e9es syst\u00e8me&nbsp;<code>INFORMATION_SCHEMA<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA ='contacts'AND TABLE_NAME ='contacts';<\/code><\/pre>\n\n\n\n<p>Cela afficherait les m\u00e9tadonn\u00e9es sur les index de notre table, y compris leurs noms et colonnes.<\/p>\n\n\n\n<p>&nbsp;Par example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">+------+------------+------------+------------+--------------+-------------+----------+------------+----------+--------+------+------------+---------+---------------+\n| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | NON_UNIQUE | INDEX_SCHEMA | INDEX_NAME | SEQ_IN_INDEX | COLUMN_NAME | COLLATION | CARDINALITY | SUB_PART | PACKED | NULLABLE | INDEX_TYPE | COMMENT |\n+------+------------+------------+------------+--------------+-------------+----------+------------+----------+--------+------+------------+---------+---------------+\n| def  | contacts   | contacts   |          0 | contacts     | PRIMARY     |            1 | id         | A        |           3 |     NULL | NULL   |         | BTREE      |         |  \n| def  | contacts   | contacts   |          1 | contacts     | idx_email   |            1 | email      | A        |           3 |     NULL | NULL   | YES    | BTREE      |         |\n+------+------------+------------+------------+--------------+-------------+----------+------------+----------+--------+------+------------+---------+---------------+<\/code><\/pre>\n\n\n\n<p>Lorsqu&#8217;un index n&#8217;est plus n\u00e9cessaire, nous pouvons le supprimer avec&nbsp;<code>DROP INDEX<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; DROP INDEX idx_name ON contacts;<\/code><\/pre>\n\n\n\n<p>Supprimer les index qui ne sont pas optimis\u00e9s et r\u00e9guli\u00e8rement utilis\u00e9s peut aider \u00e0 am\u00e9liorer les performances d&#8217;\u00e9criture et \u00e0 r\u00e9duire les exigences de stockage.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2>\n\n\n\n<p>L&#8217;ajout d&#8217;index fournit des optimisations puissantes pour l&#8217;interrogation et la manipulation des donn\u00e9es dans les tables MySQL. Les bons index peuvent grandement acc\u00e9l\u00e9rer les recherches, les filtres, le tri et les jointures.<\/p>\n\n\n\n<p>Quelques points cl\u00e9s \u00e0 retenir:<\/p>\n\n\n\n<ul>\n<li>Utilisez des index sur une seule colonne pour les colonnes fr\u00e9quemment filtr\u00e9es<\/li>\n\n\n\n<li>Les index UNIQUES emp\u00eachent les entr\u00e9es en double dans une colonne<\/li>\n\n\n\n<li>Les index sur plusieurs colonnes optimisent les requ\u00eates filtrant sur ces colonnes dans l&#8217;ordre<\/li>\n\n\n\n<li>Ne sur-indexez pas! \u00c9valuez les besoins des requ\u00eates et supprimez les index qui ne sont pas utilis\u00e9s.<\/li>\n<\/ul>\n\n\n\n<p>Tirer pleinement parti des index est crucial pour des performances optimales de base de donn\u00e9es MySQL, surtout \u00e0 mesure que les donn\u00e9es augmentent. Prenez le temps de comprendre les compromis d&#8217;indexation et les meilleures pratiques lors de la conception du sch\u00e9ma de base de donn\u00e9es et des requ\u00eates.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction aux index Les index sont une partie importante de l&#8217;optimisation des bases de donn\u00e9es MySQL. Un index permet \u00e0 la base de donn\u00e9es de trouver et de r\u00e9cup\u00e9rer les donn\u00e9es des tables beaucoup plus rapidement en stockant une liste tri\u00e9e de valeurs qui pointent vers les enregistrements complets. Sans index, MySQL doit analyser chaque ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[67,59],"tags":[],"yoast_head":"\n<title>Comment utiliser les index dans MySQL - WebHi Tutorials &amp; Documentations<\/title>\n<meta name=\"description\" content=\"Learn how to use indexes in MySQL including single-column, unique, and multi-column indexes. Improve MySQL query speed with proper indexing.\" \/>\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.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment utiliser les index dans MySQL - WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"og:description\" content=\"Learn how to use indexes in MySQL including single-column, unique, and multi-column indexes. Improve MySQL query speed with proper indexing.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webhi.technology\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T09:56:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-26T09:56:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/07\/mysql_index_fr.jpg\" \/>\n<meta name=\"author\" content=\"webhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:site\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/\"},\"author\":{\"name\":\"webhi\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\"},\"headline\":\"Comment utiliser les index dans MySQL\",\"datePublished\":\"2023-07-26T09:56:39+00:00\",\"dateModified\":\"2023-07-26T09:56:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/\"},\"wordCount\":1150,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"articleSection\":[\"Administration syst\u00e8me Linux\",\"Bases de donn\u00e9es\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/\",\"name\":\"Comment utiliser les index dans MySQL - WebHi Tutorials &amp; Documentations\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\"},\"datePublished\":\"2023-07-26T09:56:39+00:00\",\"dateModified\":\"2023-07-26T09:56:47+00:00\",\"description\":\"Learn how to use indexes in MySQL including single-column, unique, and multi-column indexes. Improve MySQL query speed with proper indexing.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webhi.com\/how-to\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment utiliser les index dans MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"name\":\"WebHi Tutorials &amp; Documentations\",\"description\":\"System administration and knowledge base\",\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\",\"name\":\"WebHi Technology\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"width\":288,\"height\":95,\"caption\":\"WebHi Technology\"},\"image\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webhi.technology\",\"https:\/\/twitter.com\/WebHiTechnology\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\",\"name\":\"webhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260\",\"caption\":\"webhi\"},\"sameAs\":[\"https:\/\/www.webhi.com\/how-to\"],\"url\":\"https:\/\/www.webhi.com\/how-to\/author\/webhi\/\"}]}<\/script>\n","yoast_head_json":{"title":"Comment utiliser les index dans MySQL - WebHi Tutorials &amp; Documentations","description":"Learn how to use indexes in MySQL including single-column, unique, and multi-column indexes. Improve MySQL query speed with proper indexing.","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.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/","og_locale":"en_US","og_type":"article","og_title":"Comment utiliser les index dans MySQL - WebHi Tutorials &amp; Documentations","og_description":"Learn how to use indexes in MySQL including single-column, unique, and multi-column indexes. Improve MySQL query speed with proper indexing.","og_url":"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/","og_site_name":"WebHi Tutorials &amp; Documentations","article_publisher":"https:\/\/www.facebook.com\/webhi.technology","article_published_time":"2023-07-26T09:56:39+00:00","article_modified_time":"2023-07-26T09:56:47+00:00","og_image":[{"url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/07\/mysql_index_fr.jpg"}],"author":"webhi","twitter_card":"summary_large_image","twitter_creator":"@WebHiTechnology","twitter_site":"@WebHiTechnology","twitter_misc":{"Written by":"webhi","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/#article","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/"},"author":{"name":"webhi","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54"},"headline":"Comment utiliser les index dans MySQL","datePublished":"2023-07-26T09:56:39+00:00","dateModified":"2023-07-26T09:56:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/"},"wordCount":1150,"commentCount":0,"publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"articleSection":["Administration syst\u00e8me Linux","Bases de donn\u00e9es"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/","url":"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/","name":"Comment utiliser les index dans MySQL - WebHi Tutorials &amp; Documentations","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/#website"},"datePublished":"2023-07-26T09:56:39+00:00","dateModified":"2023-07-26T09:56:47+00:00","description":"Learn how to use indexes in MySQL including single-column, unique, and multi-column indexes. Improve MySQL query speed with proper indexing.","breadcrumb":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-utiliser-les-index-dans-mysql-dans-linux-ubuntu-centos-debian-redhat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhi.com\/how-to\/"},{"@type":"ListItem","position":2,"name":"Comment utiliser les index dans MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.webhi.com\/how-to\/#website","url":"https:\/\/www.webhi.com\/how-to\/","name":"WebHi Tutorials &amp; Documentations","description":"System administration and knowledge base","publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhi.com\/how-to\/#organization","name":"WebHi Technology","url":"https:\/\/www.webhi.com\/how-to\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","contentUrl":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","width":288,"height":95,"caption":"WebHi Technology"},"image":{"@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webhi.technology","https:\/\/twitter.com\/WebHiTechnology"]},{"@type":"Person","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54","name":"webhi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/","url":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260","contentUrl":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260","caption":"webhi"},"sameAs":["https:\/\/www.webhi.com\/how-to"],"url":"https:\/\/www.webhi.com\/how-to\/author\/webhi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/6134"}],"collection":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/comments?post=6134"}],"version-history":[{"count":14,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/6134\/revisions"}],"predecessor-version":[{"id":6185,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/6134\/revisions\/6185"}],"wp:attachment":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/media?parent=6134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/categories?post=6134"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/tags?post=6134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}