commit cea4e6ba61c64ad30f47f192dbbcc11a9017a9d2 parent 63db50b2b1fe98788d3ac3f78c93b9344507b47a Author: Christian Grothoff <christian@grothoff.org> Date: Fri, 6 Jan 2023 13:21:18 +0100 add index on end row Diffstat:
| M | src/exchangedb/0002-work_shards.sql | | | 4 | ++++ |
1 file changed, 4 insertions(+), 0 deletions(-)
diff --git a/src/exchangedb/0002-work_shards.sql b/src/exchangedb/0002-work_shards.sql @@ -44,3 +44,7 @@ CREATE INDEX work_shards_by_job_name_completed_last_attempt_index ,completed ,last_attempt ASC ); + +CREATE INDEX work_shards_by_end_row_index + ON work_shards + (end_row DESC);