"Chad Attermann" <[EMAIL PROTECTED]> wrote: > 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. >
You can't change keyname without recreating index. Secondly keyname doesn't influence if MySQL will use index or not. If you think that MySQL should use index but it doesn't, show the output of EXPLAIN SELECT, table structure. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]