diff options
| author | Yorick Peterse <yorickpeterse@gmail.com> | 2015-11-09 19:17:40 +0300 |
|---|---|---|
| committer | Yorick Peterse <yorickpeterse@gmail.com> | 2015-11-19 13:46:38 +0300 |
| commit | 50f654161036ac0f97d9f931dc11678a9509d083 (patch) | |
| tree | 162248647cf8ba822085371e46a68aa9d42edab0 /db | |
| parent | a42d469ab2ac13ba40544e4cb40659fb6953d548 (diff) | |
Added index on issues.state
This field is queried when filtering issues and due to the lack of an
index would end up triggering a sequence scan.
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20151109134526_add_issues_state_index.rb | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/db/migrate/20151109134526_add_issues_state_index.rb b/db/migrate/20151109134526_add_issues_state_index.rb new file mode 100644 index 00000000000..1c4d2e30171 --- /dev/null +++ b/db/migrate/20151109134526_add_issues_state_index.rb @@ -0,0 +1,5 @@ +class AddIssuesStateIndex < ActiveRecord::Migration + def change + add_index :issues, :state + end +end |