blob: 3e74346a8d33e4321043c50b211de46015462523 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
class AddStatusesIndexOnAccountIdId < ActiveRecord::Migration[5.1]
disable_ddl_transaction!
def change
# Statuses queried by account_id are often sorted by id. Querying statuses
# of an account to show them in his status page is one of the most
# significant examples.
# Add this index to improve the performance in such cases.
add_index 'statuses', ['account_id', 'id'], algorithm: :concurrently, name: 'index_statuses_on_account_id_id'
remove_index 'statuses', algorithm: :concurrently, column: 'account_id', name: 'index_statuses_on_account_id'
end
end
|