LP1972738: Add index on hopeless date
authorJason Stephenson <jason@sigio.com>
Tue, 10 May 2022 15:07:25 +0000 (11:07 -0400)
committerGalen Charlton <gmc@equinoxOLI.org>
Mon, 27 Mar 2023 19:55:47 +0000 (15:55 -0400)
commit53948cd29334104a49e96a602b5e6fe3c0d66cfe
tree9da353aa7b650b921200aa6be2fe98d40ef3f441
parent14cb7af6c9810cdba11ed25d914dbe1a4fc1c025
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>
Signed-off-by: Galen Charlton <gmc@equinoxOLI.org>
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]