Additional index to improve performance
authorAndreas Steffen <andreas.steffen@strongswan.org>
Sat, 24 May 2014 10:26:20 +0000 (12:26 +0200)
committerAndreas Steffen <andreas.steffen@strongswan.org>
Sat, 31 May 2014 18:37:56 +0000 (20:37 +0200)
src/libimcv/imv/tables.sql

index fe32e7e..0002227 100644 (file)
@@ -249,12 +249,16 @@ CREATE TABLE "swid_tags" (
 );
 DROP INDEX if EXISTS "swid_tags_unique_id";
 DROP INDEX IF EXISTS "swid_tags_package_name";
+DROP INDEX IF EXISTS "swid_tags_software_id";
 CREATE INDEX "swid_tags_unique_id" ON "swid_tags" (
   "unique_id"
 );
 CREATE INDEX "swid_tags_package_name" ON "swid_tags" (
   "package_name"
 );
+CREATE INDEX "swid_tags_software_id" ON "swid_tags" (
+  "software_id"
+);
 
 DROP TABLE IF EXISTS "swid_tags_files";
 CREATE TABLE "swid_tags_files" (