Indexes for when multi-homed items become wide-spread

diff --git a/Open-ILS/src/sql/Pg/010.schema.biblio.sql b/Open-ILS/src/sql/Pg/010.schema.biblio.sql
index 58c8957..9bd925c 100644 (file)
--- a/Open-ILS/src/sql/Pg/010.schema.biblio.sql
+++ b/Open-ILS/src/sql/Pg/010.schema.biblio.sql
@@ -90,6 +90,8 @@ CREATE TABLE biblio.peer_bib_copy_map (
     peer_record BIGINT      NOT NULL REFERENCES biblio.record_entry (id),
     target_copy BIGINT      NOT NULL -- can't use fkey because of acp subtables
 );
+CREATE INDEX peer_bib_copy_map_record_idx ON biblio.peer_bib_copy_map (peer_record);
+CREATE INDEX peer_bib_copy_map_copy_idx ON biblio.peer_bib_copy_map (target_copy);
 
 CREATE TABLE biblio.monograph_part (
     id              SERIAL  PRIMARY KEY,