LP#800706: add index to serial.record_entry.record
authorGalen Charlton <gmc@esilibrary.com>
Tue, 12 May 2015 19:27:07 +0000 (15:27 -0400)
committerJason Stephenson <jstephenson@mvlc.org>
Wed, 13 May 2015 18:07:12 +0000 (14:07 -0400)
commit0632d1f137058a813baec118320cc85f6a51c101
tree23f8e8ba4fe3e1d3d8be0cf48c1029196ce105b6
parentb9c0c4962b222397a650aada2856aa40dff75031
LP#800706: add index to serial.record_entry.record

This patch adds index on the record column of serial.record_entry,
which can improve performance when displaying record details pages
in databases that have a large number MFHDs.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>
Open-ILS/src/sql/Pg/210.schema.serials.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.index-record-in-sre.sql [new file with mode: 0644]