https://rt-wiki.bestpractical.com/index.php?title=DatabaseIndexes&feed=atom&action=history
DatabaseIndexes - Revision history
2024-03-29T10:12:07Z
Revision history for this page on the wiki
MediaWiki 1.37.2
https://rt-wiki.bestpractical.com/index.php?title=DatabaseIndexes&diff=821&oldid=prev
Admin: 2 revisions imported
2016-04-06T20:08:44Z
<p>2 revisions imported</p>
<p><b>New page</b></p><div>This page is intended to capture notes about possible additional database indexes, which could be used to influence future updates to the official schemas.<br />
<br />
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.)<br />
<br />
----<br />
<br />
* Baseline: 3.8.7<br />
* Database: [[PostgreSQL]]<br />
* Database Version: 8.3<br />
* Suggested by: Dominic Hargreaves<br />
* Tested system: snapshots of rt.oucs.ox.ac.uk<br />
* Definition: CREATE INDEX groups3 on groups(lower(type::text), lower(domain::text), instance);<br />
<br />
* http://rt3.fsck.com/Ticket/Display.html?id=8568<br />
* http://rt3.fsck.com/Ticket/Display.html?id=13056<br />
<br />
----<br />
<br />
* Baseline: 3.8.7<br />
* Database: [[PostgreSQL]]<br />
* Database Version: 8.3<br />
* Suggested by: Dominic Hargreaves<br />
* Tested system: snapshots of rt.oucs.ox.ac.uk<br />
* Definition: CREATE INDEX users5 ON users (LOWER(emailaddress));<br />
<br />
* http://lists.bestpractical.com/pipermail/rt-users/2009-November/062386.html<br />
<br />
----<br />
<br />
* Baseline: 3.8.7<br />
* Database: [[PostgreSQL]]<br />
* Database Version: 8.3<br />
* Suggested by: Dominic Hargreaves<br />
* Tested system: snapshots of rt.oucs.ox.ac.uk<br />
* Definition: CREATE UNIQUE INDEX users6 on users(lower(name::text));<br />
<br />
----<br />
<br />
* Baseline: 3.8.7<br />
* Database: [[PostgreSQL]]<br />
* Database Version: 8.3<br />
* Suggested by: Dominic Hargreaves<br />
* Tested system: snapshots of rt.oucs.ox.ac.uk<br />
* Definition: CREATE INDEX principals3 on principals (disabled, principaltype);<br />
<br />
----<br />
<br />
* Baseline: 3.8.7<br />
* Database: [[PostgreSQL]]<br />
* Database Version: 8.3<br />
* Suggested by: Dominic Hargreaves<br />
* Definition: CREATE INDEX tickets6 on tickets (status, owner, type, effectiveid);</div>
Admin