From ca124374cae601975cca342e125652f41b70e309 Mon Sep 17 00:00:00 2001 From: Julien Lancelot Date: Wed, 29 May 2013 17:31:09 +0200 Subject: [PATCH] SONAR-3755 Add index on issues.root_component_id --- .../src/main/resources/org/sonar/core/persistence/schema-h2.ddl | 2 ++ .../src/main/webapp/WEB-INF/db/migrate/398_create_issues.rb | 1 + 2 files changed, 3 insertions(+) diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl index a52f49cb314..19ce838fa10 100644 --- a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl +++ b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl @@ -618,6 +618,8 @@ CREATE UNIQUE INDEX "ISSUES_KEE" ON "ISSUES" ("KEE"); CREATE INDEX "ISSUES_COMPONENT_ID" ON "ISSUES" ("COMPONENT_ID"); +CREATE INDEX "ISSUES_ROOT_COMPONENT_ID" ON "ISSUES" ("ROOT_COMPONENT_ID"); + CREATE INDEX "ISSUES_RULE_ID" ON "ISSUES" ("RULE_ID"); CREATE INDEX "ISSUES_SEVERITY" ON "ISSUES" ("SEVERITY"); diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/398_create_issues.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/398_create_issues.rb index a9cd0d37ecc..c0aebb856f8 100644 --- a/sonar-server/src/main/webapp/WEB-INF/db/migrate/398_create_issues.rb +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/398_create_issues.rb @@ -55,6 +55,7 @@ class CreateIssues < ActiveRecord::Migration add_index :issues, :kee, :name => 'issues_kee', :unique => true add_index :issues, :component_id, :name => 'issues_component_id' + add_index :issues, :root_component_id, :name => 'issues_root_component_id' add_index :issues, :rule_id, :name => 'issues_rule_id' add_index :issues, :severity, :name => 'issues_severity' add_index :issues, :status, :name => 'issues_status' -- 2.39.5