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
index c35d188..001e8e3 100644 (file)
@@ -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,