sped up page_down by about 20%
[Evergreen.git] / Open-ILS / src / sql / Pg / 040.schema.asset.sql
index ab372b5..b8ce056 100644 (file)
@@ -122,6 +122,7 @@ CREATE INDEX asset_call_number_record_idx ON asset.call_number (record);
 CREATE INDEX asset_call_number_creator_idx ON asset.call_number (creator);
 CREATE INDEX asset_call_number_editor_idx ON asset.call_number (editor);
 CREATE INDEX asset_call_number_dewey_idx ON asset.call_number (public.call_number_dewey(label));
+CREATE INDEX asset_call_number_upper_label_id_owning_lib_idx ON asset.call_number (upper(label),id,owning_lib);
 
 CREATE TABLE asset.call_number_note (
        id              BIGSERIAL                       PRIMARY KEY,