-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Alan Sparks Sent: Tuesday, May 09, 2006 9:37 PM To: CentOS mailing list Subject: Re: [CentOS] OT: MySQL Help
Thomas E Dukes wrote:
I ran the following against a table:
ALTER TABLE `products` ADD INDEX `idx_products_model` ( `products_model` );
Can this index be removed? If so, how?
Maybe DROP INDEX `idx_products_model` or ALTER TABLE `products` DROP INDEX `idx_products_model`
Thanks for the help. Wasn't sure if 'DROP' was what I needed to use. I'm not that MySQL savy. I was following a suggestion to speed up a process. The problems I'm having aren't in the same table and I was was just trying to cover any changes since the problems began.
I ran mysqlcheck on the database and got an OK on all tables. Must be something else.
Thanks!!
-- Alan Sparks, UNIX/Linux Systems Integration and Administration asparks@doublesparks.net
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos