diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-01-06 13:21:18 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-01-06 13:21:18 +0100 |
| commit | cea4e6ba61c64ad30f47f192dbbcc11a9017a9d2 (patch) | |
| tree | 40aa2be558d4f1b0f4a13363857bcec463f1a758 /src | |
| parent | 63db50b2b1fe98788d3ac3f78c93b9344507b47a (diff) | |
add index on end row
Diffstat (limited to 'src')
| -rw-r--r-- | src/exchangedb/0002-work_shards.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/exchangedb/0002-work_shards.sql b/src/exchangedb/0002-work_shards.sql index fbe7e7086..5ab08d39b 100644 --- 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); |