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?
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?