diff options
| author | Frédéric Buclin <LpSolit@gmail.com> | 2013-01-07 21:11:53 +0100 |
|---|---|---|
| committer | Frédéric Buclin <LpSolit@gmail.com> | 2013-01-07 21:11:53 +0100 |
| commit | 9426b8ea72bfa4ea7725e5499107e5b283a1a76c (patch) | |
| tree | 8d6c22ef4ff6624730b13a25702d17d118c15ad1 /Bugzilla/DB | |
| parent | 292ad609ffad27232699a5c5db2b244a28881267 (diff) | |
| download | bugzilla-9426b8ea72bfa4ea7725e5499107e5b283a1a76c.tar.gz bugzilla-9426b8ea72bfa4ea7725e5499107e5b283a1a76c.tar.xz | |
Bug 824361: Add an index on (bug_id, work_time) in the longdescs table to improve performance
r=dkl a=LpSolit
Diffstat (limited to 'Bugzilla/DB')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 7c3f9fa6c..058e78a5f 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -400,7 +400,7 @@ use constant ABSTRACT_SCHEMA => { extra_data => {TYPE => 'varchar(255)'} ], INDEXES => [ - longdescs_bug_id_idx => ['bug_id'], + longdescs_bug_id_idx => [qw(bug_id work_time)], longdescs_who_idx => [qw(who bug_id)], longdescs_bug_when_idx => ['bug_when'], ], |