summaryrefslogtreecommitdiff
path: root/maintenance/ibm_db2/patch-change_tag-indexes.sql
blob: 1621a0380e318debe1bcce3e73d5c549d1bdd7f1 (plain)
1
2
3
4
5
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);