LP1972738: Add index on hopeless date user/dyrcona/lp1972738-add-index
authorJason Stephenson <jason@sigio.com>
Tue, 10 May 2022 15:07:25 +0000 (11:07 -0400)
committerJason Stephenson <jason@sigio.com>
Tue, 10 May 2022 15:07:25 +0000 (11:07 -0400)
commitbb3a8086a969789ed02df5a3edab0a9fac3c1788
tree4023dd654182bfdd4c2e1354b8a43f7aad2ede1a
parent1d25efcefd23e3ed3eae3f1905fc0cea5ff02bc2
LP1972738: Add index on hopeless date

Add an index on action.hold_request hopeless_date column to speed up
hopeless holds processing.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Open-ILS/src/sql/Pg/090.schema.action.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.add-hopeless-date-index.sql [new file with mode: 0644]