OpenWritings.net

-- Check what indexes are already defined for a table.
SHOW INDEX FROM tablename;
 
-- Create the index for col1, col2, ...
CREATE INDEX index_name ON tablename(col1, col2, ...);