Looking for dropping indexes in MySQL table? Here is a simple how to:
Drop Index MySql
Removing index from a column or a field is quite simple. All you need to know is the exact index name of the table you’re working on.
To check and display the index names of your table, refer to the post below:
View, Add and Drop Indexes in MySql
For dropping the index of your table, execute the following SQL query:
ALTER TABLE test_table DROP INDEX your_index_id;
where your_index_id is the name of your index.
WARNING: Before You Drop Any Index
If you have huge amount of data in your table and this specific field or index is being used in your MySQL queries, make sure you modify those queries and start using the alternate field for your queries before dropping index. Otherwise there are mostly chances that your website performance will affect, making your website load time slower or even worst.