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` -- Alan Sparks, UNIX/Linux Systems Integration and Administration <asparks at doublesparks.net>