LP#1200735: improve performance of patron search by username user/gmcharlt/lp1200735_usrname_index
authorGalen Charlton <gmc@esilibrary.com>
Fri, 12 Jul 2013 19:10:32 +0000 (15:10 -0400)
committerGalen Charlton <gmc@esilibrary.com>
Fri, 12 Jul 2013 19:10:32 +0000 (15:10 -0400)
commit3568e4c376c4827604f14bd6347bf4c7cef06262
tree7b622d2b40786fb0d32bc445ede135800507212a
parent82e6978f5b33909c2cbb646c1dd36086e7ae7254
LP#1200735: improve performance of patron search by username

This patch adds an additional index on actor.usr.usrname.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/src/sql/Pg/005.schema.actors.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usrname_index.sql [new file with mode: 0644]