MySQL Indexes

[gerardg]

Looking at a table using phpMyAdmin it lists under 'Indexes':

Keyname Unique Field Action
PRIMARY Yes Type_ID Drop

Type_ID Yes Type_ID Drop

Type_ID_2 No Type_ID Drop

Type_ID_2 No Name Drop

There are three indexes for 'Type_ID'? Can I drop all but the primary index?

[Anon]

It appears that the index with keyname 'Type_ID' is a duplicate... but I wouldn't delete the index 'Type_ID_2', as it isn't just indexing a single column, it is indexing the combination of Type_ID WITH Name - which is different from just a single index on Type_ID.

So, imho, you could drop the single index 'type_id'.