aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/exchangedb/0002-work_shards.sql4
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);