DatabaseIndexes

This page is intended to capture notes about possible additional database indexes, which could be used to influence future updates to the official schemas.

Ideally stick to the fixed format so that the details are clear (although feel free to add other relevant fields and free-form rationales, etc.)

---

• Baseline: 3.8.7
• Database: PostgreSQL
• Database Version: 8.3
• Suggested by: Dominic Hargreaves
• Tested system: snapshots of rt.oucs.ox.ac.uk
• Definition: CREATE INDEX groups3 on groups(lower(type::text), lower(domain::text), instance);

• http://rt3.fsck.com/Ticket/Display.html?id=8568
• http://rt3.fsck.com/Ticket/Display.html?id=13056

---

• Baseline: 3.8.7
• Database: PostgreSQL
• Database Version: 8.3
• Suggested by: Dominic Hargreaves
• Tested system: snapshots of rt.oucs.ox.ac.uk
• Definition: CREATE INDEX users5 ON users (LOWER(emailaddress));

• http://lists.bestpractical.com/pipermail/rt-users/2009-November/062386.html

---

• Baseline: 3.8.7
• Database: PostgreSQL
• Database Version: 8.3
• Suggested by: Dominic Hargreaves
• Tested system: snapshots of rt.oucs.ox.ac.uk
• Definition: CREATE UNIQUE INDEX users6 on users(lower(name::text));

---

• Baseline: 3.8.7
• Database: PostgreSQL
• Database Version: 8.3
• Suggested by: Dominic Hargreaves
• Tested system: snapshots of rt.oucs.ox.ac.uk
• Definition: CREATE INDEX principals3 on principals (disabled, principaltype);

---

• Baseline: 3.8.7
• Database: PostgreSQL
• Database Version: 8.3
• Suggested by: Dominic Hargreaves
• Definition: CREATE INDEX tickets6 on tickets (status, owner, type, effectiveid);