MySQL - Create indexes to speed up SQL query

By xngo on August 11, 2019

-- 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, ...);

About the author

Xuan Ngo is the founder of He currently lives in Montreal, Canada. He loves to write about programming and open source subjects.