drop index INDEX_NAME on TABLE_NAME;
ALTER TABLE TABLE_NAME add index INDEX_NAME(col1, col2);
SHOW INDEX FROM yourtable;
Comments are closed.