> -----Original Message----- > From: centos-bounces at centos.org > [mailto:centos-bounces at 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 at doublesparks.net> > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos >