From 50f654161036ac0f97d9f931dc11678a9509d083 Mon Sep 17 00:00:00 2001
From: Yorick Peterse <yorickpeterse@gmail.com>
Date: Mon, 9 Nov 2015 17:17:40 +0100
Subject: 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.
---
 db/migrate/20151109134526_add_issues_state_index.rb | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 db/migrate/20151109134526_add_issues_state_index.rb

(limited to 'db/migrate/20151109134526_add_issues_state_index.rb')

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
-- 
cgit v1.2.1