Patch from Galen Charlton: This resolves a performance issue found by EG Indiana...

[working/Evergreen.git] / Open-ILS / src / sql / Pg / 040.schema.asset.sql

diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql
index c35d188..001e8e3 100644 (file)
--- a/Open-ILS/src/sql/Pg/040.schema.asset.sql
+++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql
@@ -157,6 +157,7 @@ CREATE TABLE asset.stat_cat_entry_copy_map (
        owning_copy     BIGINT          NOT NULL,
        CONSTRAINT sce_once_per_copy UNIQUE (owning_copy,stat_cat)
 );
+CREATE INDEX scecm_owning_copy_idx ON asset.stat_cat_entry_copy_map(owning_copy);
 
 CREATE TABLE asset.copy_note (
        id              BIGSERIAL                       PRIMARY KEY,