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:51:30 +0000 (15:51 -0400)
commit71df266db6b8ba782ef2d4b00032974c44713ce8
tree3d9c0c78bd589ccef21f433011ccfaf99d233e96
parentd045f7bfa5ba1465d75ecc47e22d6ff0fb1c4bc6
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]