diff options
| author | Belen Pruvost <belen.pruvost@sonarsource.com> | 2021-04-09 12:29:00 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2021-04-13 20:03:51 +0000 |
| commit | e0a058d7e9dc8cb4dce7b25e01d9702aa3554576 (patch) | |
| tree | 98fba6d1c28646ba1968135b47302b5eae7a76ba /server/sonar-db-dao/src/schema | |
| parent | b26ae4c3687b9bf4a2ae809702c5663959627a2f (diff) | |
| download | sonarqube-e0a058d7e9dc8cb4dce7b25e01d9702aa3554576.tar.gz sonarqube-e0a058d7e9dc8cb4dce7b25e01d9702aa3554576.zip | |
SONAR-14681 improve project_measures metric purge performance
Diffstat (limited to 'server/sonar-db-dao/src/schema')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index 6a5712939d0..3430f5a74c4 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -637,6 +637,7 @@ CREATE TABLE "PROJECT_MEASURES"( ALTER TABLE "PROJECT_MEASURES" ADD CONSTRAINT "PK_PROJECT_MEASURES" PRIMARY KEY("UUID"); CREATE INDEX "MEASURES_COMPONENT_UUID" ON "PROJECT_MEASURES"("COMPONENT_UUID"); CREATE INDEX "MEASURES_ANALYSIS_METRIC" ON "PROJECT_MEASURES"("ANALYSIS_UUID", "METRIC_UUID"); +CREATE INDEX "PROJECT_MEASURES_METRIC" ON "PROJECT_MEASURES"("METRIC_UUID"); CREATE TABLE "PROJECT_QGATES"( "PROJECT_UUID" VARCHAR(40) NOT NULL, |