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?