From 1108b8b634cf60cedf9bb7e722146a9ea08e1dd2 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Tue, 10 Dec 2013 15:16:21 -0500 Subject: [PATCH] LP1223903 - Add indexes to authority.record_entry. We want indexes on edit_date and create_date for authority.record_entry so that date-based searching is faster for authority record export. It likely will prove useful for other features. Signed-off-by: Jason Stephenson Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/011.schema.authority.sql | 2 ++ .../src/sql/Pg/upgrade/XXXX.index.authority_record_entry.sql | 2 ++ 2 files changed, 4 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.index.authority_record_entry.sql diff --git a/Open-ILS/src/sql/Pg/011.schema.authority.sql b/Open-ILS/src/sql/Pg/011.schema.authority.sql index d40bf31d03..7033773ee1 100644 --- a/Open-ILS/src/sql/Pg/011.schema.authority.sql +++ b/Open-ILS/src/sql/Pg/011.schema.authority.sql @@ -135,6 +135,8 @@ CREATE TABLE authority.record_entry ( ); CREATE INDEX authority_record_entry_creator_idx ON authority.record_entry ( creator ); CREATE INDEX authority_record_entry_editor_idx ON authority.record_entry ( editor ); +CREATE INDEX authority_record_entry_create_date_idx ON authority.record_entry ( create_date ); +CREATE INDEX authority_record_entry_edit_date_idx ON authority.record_entry ( edit_date ); CREATE INDEX authority_record_deleted_idx ON authority.record_entry(deleted) WHERE deleted IS FALSE OR deleted = false; CREATE TRIGGER a_marcxml_is_well_formed BEFORE INSERT OR UPDATE ON authority.record_entry FOR EACH ROW EXECUTE PROCEDURE biblio.check_marcxml_well_formed(); CREATE TRIGGER b_maintain_901 BEFORE INSERT OR UPDATE ON authority.record_entry FOR EACH ROW EXECUTE PROCEDURE evergreen.maintain_901(); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.index.authority_record_entry.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.index.authority_record_entry.sql new file mode 100644 index 0000000000..1c8e03c955 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.index.authority_record_entry.sql @@ -0,0 +1,2 @@ +CREATE INDEX authority_record_entry_create_date_idx ON authority.record_entry ( create_date ); +CREATE INDEX authority_record_entry_edit_date_idx ON authority.record_entry ( edit_date ); -- 2.43.2