From e7655c9f6a11aee1ef0c193f34a7b405c0e47d38 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 17 Jan 2017 13:35:07 -0500 Subject: [PATCH] JBAS-1554 Aged circ parent circ index Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/aged-circs-api.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/KCLS/sql/schema/deploy/aged-circs-api.sql b/KCLS/sql/schema/deploy/aged-circs-api.sql index 8492367480..5fc7853789 100644 --- a/KCLS/sql/schema/deploy/aged-circs-api.sql +++ b/KCLS/sql/schema/deploy/aged-circs-api.sql @@ -141,3 +141,8 @@ $$ LANGUAGE 'plpgsql'; COMMIT; + +-- create index on parent_circ after main transaction. +CREATE INDEX action_aged_circulation_parent_circ_idx + ON action.aged_circulation (parent_circ); + -- 2.11.0