Skip to content

Instantly share code, notes, and snippets.

@karuna
Created June 13, 2017 05:01
Show Gist options
  • Save karuna/43722c264e4b49c323c9247cca9e63cc to your computer and use it in GitHub Desktop.
Save karuna/43722c264e4b49c323c9247cca9e63cc to your computer and use it in GitHub Desktop.
change index sql
ALTER TABLE `compathy2_production`.`spots` DROP INDEX `index_spots_on_name`, ADD INDEX `index_spots_on_name` (`name`(10));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment