7ed0399fe488f399e7f859c86819b238d419e2b2
[evergreen-equinox.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.schema.add-hopeless-date-index.sql
1 BEGIN;
2
3 --SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
4
5 CREATE INDEX hold_request_hopeless_date_idx ON action.hold_request (hopeless_date);
6
7 COMMIT;
8
9 ANALYZE action.hold_request;