From 9f2d2e40c354e612cbe404a87fe993cccdc9b8f3 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 20 Jun 2008 19:30:59 +0000 Subject: [PATCH] adding tag,subfield index by default git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_2@9899 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 27f2586618..42d0632491 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -145,6 +145,7 @@ CREATE TABLE metabib.full_rec ( value TEXT NOT NULL, index_vector tsvector NOT NULL ); +CREATE INDEX metabib_full_rec_tag_subfield_idx ON metabib.full_rec (tag,subfield); CREATE INDEX metabib_full_rec_record_idx ON metabib.full_rec (record); CREATE TRIGGER metabib_full_rec_fti_trigger BEFORE UPDATE OR INSERT ON metabib.full_rec -- 2.11.0