# Terminal
gem install lol_dba
cd <RAILS_PROJECT>
lol_dba db:find_indexes
* TIP: if you have a problem with the index name('index name too long') you can solve with the :name option. Something like :name => 'my_index'.
* run `rails g migration AddMissingIndexes` and add the following content:
class AddMissingIndexes < ActiveRecord::Migration
def change
add_index :comments, :user_id
add_index :comments, :post_id
add_index :posts, :user_id
end
end# Terminal gem install squasher squasher YYYY/MM/DD