adding some useful indexes
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 29 Aug 2006 06:36:18 +0000 (06:36 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 29 Aug 2006 06:36:18 +0000 (06:36 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@5755 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/sql/Pg/090.schema.action.sql

index 84eccec..7e6c61f 100644 (file)
@@ -179,6 +179,12 @@ CREATE TABLE action.hold_request (
        email_notify            BOOL                            NOT NULL DEFAULT TRUE
 );
 
+CREATE INDEX hold_request_target_idx ON action.hold_request (target);
+CREATE INDEX hold_request_usr_idx ON action.hold_request (usr);
+CREATE INDEX hold_request_pickup_lib_idx ON action.hold_request (pickup_lib);
+CREATE INDEX hold_request_current_copy_idx ON action.hold_request (current_copy);
+CREATE INDEX hold_request_prev_check_time_idx ON action.hold_request (prev_check_time);
+
 
 CREATE TABLE action.hold_notification (
        id              SERIAL                          PRIMARY KEY,