From fc97fd7c94b2024bd09c82a0b3e15f36477e6aed Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 8 Dec 2014 10:34:26 -0500 Subject: [PATCH] LP#1380709 fund_debit.invoice_entry INDEX Adds index on new acq.fund_debit.invoice_entry column, since fund_debit can get quite large. Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql index aca7918dbb..7575ef9535 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql @@ -7,4 +7,6 @@ ALTER TABLE acq.fund_debit REFERENCES acq.invoice_entry (id) ON DELETE SET NULL; +CREATE INDEX fund_debit_invoice_entry_idx ON acq.fund_debit (invoice_entry); + COMMIT; -- 2.11.0