From d2d731815091da1695947db929930249ba963524 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 15 Jan 2014 16:01:36 -0500 Subject: [PATCH] Add a useful index Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 5a0fd26c53..9cdcf716c0 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -301,7 +301,8 @@ CREATE TABLE metabib.record_sorter ( attr TEXT NOT NULL REFERENCES config.record_attr_definition (name) ON DELETE CASCADE, value TEXT NOT NULL ); -CREATE INDEX metabib_sorter_source_idx ON metabib.record_sorter (source); +CREATE INDEX metabib_sorter_source_idx ON metabib.record_sorter (source); -- we may not need one of this or the next ... stats will tell +CREATE INDEX metabib_sorter_s_a_idx ON metabib.record_sorter (source, attr); CREATE INDEX metabib_sorter_a_v_idx ON metabib.record_sorter (attr, value); -- 2.11.0