1621a0380e318debe1bcce3e73d5c549d1bdd7f1
[lhc/web/wiklou.git] / maintenance / ibm_db2 / patch-change_tag-indexes.sql
1 CREATE UNIQUE INDEX change_tag_rc_tag ON change_tag (ct_rc_id,ct_tag);
2 CREATE UNIQUE INDEX change_tag_log_tag ON change_tag (ct_log_id,ct_tag);
3 CREATE UNIQUE INDEX change_tag_rev_tag ON change_tag (ct_rev_id,ct_tag);
4 -- Covering index, so we can pull all the info only out of the index.
5 CREATE INDEX change_tag_tag_id ON change_tag (ct_tag,ct_rc_id,ct_rev_id,ct_log_id);