List:General Discussion« Previous MessageNext Message »
From:C.R.Vegelin Date:November 28 2005 4:04pm
Subject:drop primary key too slow ?
View as plain text  
Hi Friends,
I have a MyISAM table with about 10 million rows.
When I drop the (multi-column) Primary Key (PK) it takes more than 10 minutes.
I thought that any key or index was a kind of table in itself.
And if so, dropping the PK could be as fast as a Truncate statement (a second).
Am I missing something here ?
I am using MySQL version 5.0.15.

drop primary key too slow ?C.R.Vegelin28 Nov