diff options
| author | Julien Lancelot <julien.lancelot@gmail.com> | 2013-05-29 17:31:09 +0200 |
|---|---|---|
| committer | Julien Lancelot <julien.lancelot@gmail.com> | 2013-05-29 17:31:09 +0200 |
| commit | ca124374cae601975cca342e125652f41b70e309 (patch) | |
| tree | 15bb7eded1476af68b6c40a83cfc99b1c5ebbc2e /sonar-core/src | |
| parent | 79a3c34591de315cbf89a618cb88eb856af6672f (diff) | |
| download | sonarqube-ca124374cae601975cca342e125652f41b70e309.tar.gz sonarqube-ca124374cae601975cca342e125652f41b70e309.zip | |
SONAR-3755 Add index on issues.root_component_id
Diffstat (limited to 'sonar-core/src')
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl | 2 |
1 files changed, 2 insertions, 0 deletions
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"); |