Remove redundant indexes created by the default migration files - Githubissues

mbleigh / acts-as-taggable-on

A tagging plugin for Rails applications that allows for custom tagging along dynamic contexts.

http://mbleigh.lighthouseapp.com/projects/10116-acts-as-taggable-on

MIT License

4.97k stars 1.2k forks source link

Remove redundant indexes created by the default migration files #1092

Open JewelSam opened 1 year ago

JewelSam commented 1 year ago

Context Several redundant indexes are created by the default migration files generated Issue: https://github.com/mbleigh/acts-as-taggable-on/issues/1083

Solution

remove index_taggings_on_tag_id - can be replaced by taggings_idx
remove index_taggings_on_taggable_id - can be replaced by taggings_idy or taggings_taggable_context_idx
remove index_taggings_on_taggable_type - can be replaced by index_taggings_on_taggable_type_and_taggable_id
remove index_taggings_on_tagger_id - can be replaced by index_taggings_on_tagger_id_and_tagger_type