From a123f470f077654ad2cbbe731f63674e0621038c Mon Sep 17 00:00:00 2001 From: Andreas Steffen Date: Sat, 24 May 2014 12:26:20 +0200 Subject: [PATCH] Additional index to improve performance --- src/libimcv/imv/tables.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/src/libimcv/imv/tables.sql b/src/libimcv/imv/tables.sql index fe32e7e7b0..0002227ede 100644 --- a/src/libimcv/imv/tables.sql +++ b/src/libimcv/imv/tables.sql @@ -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" ( -- 2.47.2