From 68bcdbb2778711bc855a463487fb79b5c1b2ad8b Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 5 Apr 2011 15:19:14 -0400 Subject: [PATCH] Indexes for when multi-homed items become wide-spread --- Open-ILS/src/sql/Pg/010.schema.biblio.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/010.schema.biblio.sql b/Open-ILS/src/sql/Pg/010.schema.biblio.sql index 58c89576c1..9bd925ca1f 100644 --- 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, -- 2.11.0