LP#783486: Improve authority lookup performance

[evergreen-equinox.git] / Open-ILS / src / sql / Pg / upgrade / 0535.schema.authority_indexes.sql

diff --git a/Open-ILS/src/sql/Pg/upgrade/0535.schema.authority_indexes.sql b/Open-ILS/src/sql/Pg/upgrade/0535.schema.authority_indexes.sql
new file mode 100644 (file)
index 0000000..cf55c58
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/0535.schema.authority_indexes.sql
@@ -0,0 +1,9 @@
+BEGIN;
+
+INSERT INTO config.upgrade_log (version) VALUES ('0535'); --dbs
+
+CREATE INDEX authority_record_deleted_idx ON authority.record_entry(deleted) WHERE deleted IS FALSE OR deleted = false;
+
+CREATE INDEX authority_full_rec_subfield_a_idx ON authority.full_rec (value) WHERE subfield = 'a';
+
+COMMIT;