class AddIndexForSlowQueries < ActiveRecord::Migration[6.0]
  def change
    add_index :network_ssids, :location_network_id
    add_index :commands_router_inventories, [:command_id, :router_inventory_id], name: "commands_router_inventories_c_id_ri_id"
    add_index :commands_router_inventories, :command_id
    add_index :commands_router_inventories, :router_inventory_id, name: "commands_router_inventories_ri_id"
    add_index :loggings, :location_network_id
  end
end
