MySQL: Add index to an active table
My _sitecustomers table has around 67,000 records and after optimizing the site's search I decided I should have indexed 1 or 2 more columns to speed up the query. Is there a way to index an already active table with this many records?
67k is not a real big number of records. A simple ALTER TABLE statement will work:
ALTER TABLE `_sitecustomers` ADD INDEX `col1` (`col1`), ADD INDEX `col2` (`col2`);