Hello,
Through some strange quirk in my MySQL console application (an older version of
PHPMyAdmin), 4 indexes that I created on different columns of a table all resulted in
indexes with the same keyname, that of the first column that was indexed. The field
of each index is correct, just the keyname is wrong on 3 of them.
Keyname Unique Field Action
BUYAGENTID No BUYAGENTID Drop
BUYAGENTID No SELLAGENTID Drop
BUYAGENTID No BUYACCOUNTID Drop
BUYAGENTID No SELLACCOUNTID Drop
I noticed that the 3 indexes with the wrong keyname are never used, even with simple
queries where they definitely should be used. I need to change the keyname of these
indexes without having to drop and re-create them as this table is now *very* large
and it would take hours to reindex 3 columns. Any assistance in changing the keyname,
either through common commands or low-level file editing, would be greatly appreciated.
Thanks a lot!
Chad Attermann
