indexing - MySQL dropping all indexes from table -


I have a MySQL database which, for some time, moves with it for several changes. Recently I looked at it and I saw that in some cases I doubled the index on the same area. Some indexes are unavailable, and generally there is a big disturbance in all the indices.

I want to drop all the indexes from a table. Later I have a ready script which will run ALTER TABLE and add related indexes.

Is there a way to leave all indexes from a table?

If you have phpmyadmin or any other device that you can easily graphic.

or for each index 

  Eltar table 'table' drop indices `name index '

you index to 

 . Show
from `table`

Comments

Post a Comment