Roland, On 1/12/09, Roland Bouman <[email protected]> wrote: > > Hi! > > > On Fri, Jan 9, 2009 at 4:39 AM, Sheeri K. Cabral <[email protected]> wrote: > > Why isn't dropping an index/primary key/unique key/foreign key an online > > operation? Or rather, why is it slow? It should be easy to drop an > index, > > there's no updating needed other than "don't use the index object any > more". > > > I think in the case of innodb, dropping the primary key essentially > involves creating a new primary key *and* reorder the data according > to the order of the key entries. The secondary indexes would need to > be updated as well to point to the new primary key's index entry.
This totally makes sense for innodb and primary keys, but regular indexes/foreign keys/unique keys shouldn't have a problem with it. It does, I think, come back to "how the storage engines use the indexes"....so I am in full agreement that EXPLAIN ALTER TABLE should work. :) -Sheeri
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
