diff options
| author | simonbrandhof <simon.brandhof@gmail.com> | 2011-11-02 07:50:52 +0100 |
|---|---|---|
| committer | simonbrandhof <simon.brandhof@gmail.com> | 2011-11-02 07:50:52 +0100 |
| commit | d370ff3d3dff3cc59d092ce2eb48edd5ae8198df (patch) | |
| tree | 51bb47a1e1706f7747df5f3a424c037321ec6c9e /sonar-testing-harness/src/main | |
| parent | 75d94af97eec8d3f4f68b3535ffd3365456e490f (diff) | |
| download | sonarqube-d370ff3d3dff3cc59d092ce2eb48edd5ae8198df.tar.gz sonarqube-d370ff3d3dff3cc59d092ce2eb48edd5ae8198df.zip | |
SONAR-2962 Add an index on dependencies.project_snapshot_id to improve performance
Diffstat (limited to 'sonar-testing-harness/src/main')
| -rw-r--r-- | sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl b/sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl index 7fa023eb3f2..60d8419db75 100644 --- a/sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl +++ b/sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl @@ -135,6 +135,7 @@ create table DEPENDENCIES ( ); CREATE INDEX DEPS_FROM_SID ON DEPENDENCIES (FROM_SNAPSHOT_ID); CREATE INDEX DEPS_TO_SID ON DEPENDENCIES (TO_SNAPSHOT_ID); +CREATE INDEX DEPS_PRJ_SID ON DEPENDENCIES (PROJECT_SNAPSHOT_ID); create table EVENTS ( ID INTEGER not null, |