{"id":62893,"date":"2020-11-03T16:01:17","date_gmt":"2020-11-03T21:01:17","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/?p=62893"},"modified":"2021-08-16T15:29:12","modified_gmt":"2021-08-16T19:29:12","slug":"mariadb-adding-removing-indexes","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/","title":{"rendered":"MariaDB: Adding and Removing Indexes"},"content":{"rendered":"<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"538\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB-1024x538.png\" alt=\"\" class=\"wp-image-65614\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB-1024x538.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB-300x158.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB-768x403.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB.png 1200w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n\n<p><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-create-database-tables-with-sql\/\">Database tables<\/a> often need altering during their life cycle. As your needs change, the data you store will often need to change to reflect these needs. Perhaps you recently added a column to your database, or you find out that certain columns are getting searched. In this article, we will explore how to add and remove indexes for a database table using <strong><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-sql\/\">MySQL<\/a><\/strong> or <strong>MariaDB<\/strong> management systems.<\/p>\n\n\n\n<p>Topics Include<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"#what\">What is an Index?<\/a><\/li><li><a href=\"#viewing\">Viewing Indexes on a Table<\/a><\/li><li><a href=\"#naming\">Naming an Index<\/a><\/li><li><a href=\"#multi\">Multi-column Index<\/a><\/li><li><a href=\"#adding\">Adding an Index to an Existing Table<\/a><\/li><li><a href=\"#removing\">Removing an Index<\/a><\/li><\/ul>\n\n\n\n<p class=\"alert alert-info\">Use database indexes to optimize the database operations on your <a href=\"https:\/\/www.inmotionhosting.com\/dedicated-servers\">Dedicated Hosting<\/a> server!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what\"><strong>What is an Index?<\/strong><\/h2>\n\n\n\n<p>Database table indexes help improve the speed of search queries when using certain columns in a database array. An <strong>index<\/strong> is effectively a type of table, optimized for the column or columns assigned to it. A separate index table is created for each defined index and is invisible to all users of the database.<br><br>Before you create an index, take a look at the data and columns to consider which ones will be used to create search queries. You will want to make one or more indexes based on those columns.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"viewing\"><strong>Viewing Indexes on a <\/strong>T<strong>able<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p>To view the indexes that are currently assigned to a table, simply use the following statement template in your database command line or the SQL tab within <a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/\">phpMyAdmin<\/a>:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SHOW INDEXES FROM <em>table_name<\/em>;<\/pre>\n\n\n\n<p>Example: To show the indexes on the \u201cuser\u201d table, the command will be as   follows:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SHOW INDEXES FROM user;<\/pre>\n\n\n\n<p>Run the command and all indexes along with relevant information will be listed.<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"naming\"><strong>Naming an Index<\/strong><\/h2>\n\n\n\n<p>When deciding to name an index, remember it is only a name that you and other administrators need to understand. They are not column names, nor are they seen or used outside of the database syntax. This means you can name it whatever you want. However, naming an index for a user_name column \u201cfred\u201d is far less descriptive than naming it \u201cuser\u201d or sticking with \u201cuser_name\u201d.<br><br>When naming an index that only has one column involved, it is very common to use the name of the column. For instance, if you want to create an index for the \u201clast_name\u201d column, you would simply name it \u201clast_name\u201d when creating the index. The single column index is the most common, so most of them are very descriptive when named this way.<br><br>If you have an index that involves more than one column, make sure to give it a descriptive name. For example, if you create an index that involves the \u201cstreet_number\u201d and \u201cstreet_name\u201d columns, you may want to name it \u201caddress\u201d.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"multi\"><strong>Multi-column <\/strong>I<strong>ndexes<\/strong><\/h2>\n\n\n\n<p>Using multiple columns to create an index is not as common as using single columns, but it can be done if necessary. When assigning more than one column to an index, remember that the left most column is the base for the index.<br><br>If you create an index called \u201cname\u201d that includes (\u201clast_name\u201d, \u201cfirst_name\u201d), then the index is built based on the last_name column. This means that it optimizes search queries that are looking for the last_name AND the first_name columns, or simply just the last_name column. It does not optimize search queries looking for only the first_name column.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"adding\"><strong>Adding an <\/strong>I<strong>ndex to an Existing Table<\/strong><\/h2>\n\n\n\n<p>If you have an existing table on which you want to add an index, use the following template for your SQL statement:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE INDEX <em>index_name<\/em> ON <em>table_name<\/em>(<em>column_name1, column_name2, etc<\/em>);<\/pre>\n\n\n\n<p>For our example, say we have a table named \u201cuser\u201d with the following columns: (id, first_name, last_name). The table has a primary key that was added upon creation for the \u201cid\u201d column. We decided to add an index for the \u201cfirst_name\u201d column. We also decided to give this index the name \u201cfirst\u201d instead of sticking with the column name convention mentioned above. This is so you can see the difference when the data is displayed later. The statement to create this index will look like this.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE INDEX first ON user(first_name);<\/pre>\n\n\n\n<p>When creating a multi_column index based on last_name and first_name it would look like this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE INDEX name ON user(last_name, first_name);<\/pre>\n\n\n\n<p>After running the single column example from above and receiving no errors, run the SHOW INDEXES statement for the \u201cuser\u201d table. You will see that the new index was added.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"removing\"><strong>Removing an Index<\/strong><\/h2>\n\n\n\n<p>While adding an index does increase the speed of search, it also slows down other things such as running INSERT or UPDATE statements against the table. If you find that an index is not used very often, you may want to remove it to help increase insertion and update speeds.<\/p>\n\n\n\n<p>Removing an index is just as easy as adding one, but with a slightly different command statement. Below is the command template you will use to remove an index.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLE <em>table_name<\/em> DROP INDEX <em>index_name<\/em>;<\/pre>\n\n\n\n<p>To continue with our current example, we will be removing the index we created earlier, named \u201cfirst\u201d. The command statement will look like this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLE user DROP INDEX first;<\/pre>\n\n\n\n<p>After running that statement and receiving no errors, run the SHOW INDEXES statement once again. You will see the \u201cfirst\u201d index has been removed and the list now only shows the original primary index.<\/p>\n\n\n\n<p>Now you understand how and when to add and remove indexes to your database tables. This should help you in optimizing your database speeds to help increase overall performance for your application or website.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database tables often need altering during their life cycle. As your needs change, the data you store will often need to change to reflect these needs. Perhaps you recently added a column to your database, or you find out that certain columns are getting searched. In this article, we will explore how to add and<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/\"> Read More ><\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4305],"tags":[],"class_list":["post-62893","post","type-post","status-publish","format-standard","hentry","category-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Adding and Removing Indexes in MariaDB<\/title>\n<meta name=\"description\" content=\"In this article, we will explore how to optimize database performance by adding and removing indexes in MariaDB using standard MySQL commands.\" \/>\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.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adding and Removing Indexes in MariaDB\" \/>\n<meta property=\"og:description\" content=\"In this article, we will explore how to optimize database performance by adding and removing indexes in MariaDB using standard MySQL commands.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-03T21:01:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-16T19:29:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Scott Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scott Mitchell\" \/>\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.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"MariaDB: Adding and Removing Indexes\",\"datePublished\":\"2020-11-03T21:01:17+00:00\",\"dateModified\":\"2021-08-16T19:29:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/\"},\"wordCount\":893,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB-1024x538.png\",\"articleSection\":[\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/\",\"name\":\"Adding and Removing Indexes in MariaDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB-1024x538.png\",\"datePublished\":\"2020-11-03T21:01:17+00:00\",\"dateModified\":\"2021-08-16T19:29:12+00:00\",\"description\":\"In this article, we will explore how to optimize database performance by adding and removing indexes in MariaDB using standard MySQL commands.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB.png\",\"width\":1200,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB: Adding and Removing Indexes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\",\"name\":\"Scott Mitchell\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Adding and Removing Indexes in MariaDB","description":"In this article, we will explore how to optimize database performance by adding and removing indexes in MariaDB using standard MySQL commands.","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.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/","og_locale":"en_US","og_type":"article","og_title":"Adding and Removing Indexes in MariaDB","og_description":"In this article, we will explore how to optimize database performance by adding and removing indexes in MariaDB using standard MySQL commands.","og_url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2020-11-03T21:01:17+00:00","article_modified_time":"2021-08-16T19:29:12+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB.png","type":"image\/png"}],"author":"Scott Mitchell","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Scott Mitchell","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"MariaDB: Adding and Removing Indexes","datePublished":"2020-11-03T21:01:17+00:00","dateModified":"2021-08-16T19:29:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/"},"wordCount":893,"commentCount":2,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB-1024x538.png","articleSection":["Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/","url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/","name":"Adding and Removing Indexes in MariaDB","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB-1024x538.png","datePublished":"2020-11-03T21:01:17+00:00","dateModified":"2021-08-16T19:29:12+00:00","description":"In this article, we will explore how to optimize database performance by adding and removing indexes in MariaDB using standard MySQL commands.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Adding-and-Removing-Indexes-in-MariaDB.png","width":1200,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"MariaDB: Adding and Removing Indexes"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed","name":"Scott Mitchell","url":"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":4305,"name":"Working with Databases","slug":"databases","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/62893","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=62893"}],"version-history":[{"count":7,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/62893\/revisions"}],"predecessor-version":[{"id":82756,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/62893\/revisions\/82756"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=62893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=62893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=62893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}