ALTER TABLE `products` DROP INDEX `idx_products_model`; you might consider running either mysqlcheck or mysqlisamchk first... http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html Be sure to read the docs about the differences. Don't just run one of these. Thomas E Dukes wrote: > > Can this index be removed? If so, how? >