summaryrefslogtreecommitdiff
path: root/maintenance/ibm_db2/patch-change_tag-indexes.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/ibm_db2/patch-change_tag-indexes.sql')
-rw-r--r--maintenance/ibm_db2/patch-change_tag-indexes.sql5
1 files changed, 0 insertions, 5 deletions
diff --git a/maintenance/ibm_db2/patch-change_tag-indexes.sql b/maintenance/ibm_db2/patch-change_tag-indexes.sql
deleted file mode 100644
index 1621a038..00000000
--- a/maintenance/ibm_db2/patch-change_tag-indexes.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-CREATE UNIQUE INDEX change_tag_rc_tag ON change_tag (ct_rc_id,ct_tag);
-CREATE UNIQUE INDEX change_tag_log_tag ON change_tag (ct_log_id,ct_tag);
-CREATE UNIQUE INDEX change_tag_rev_tag ON change_tag (ct_rev_id,ct_tag);
--- Covering index, so we can pull all the info only out of the index.
-CREATE INDEX change_tag_tag_id ON change_tag (ct_tag,ct_rc_id,ct_rev_id,ct_log_id);