aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/0002-work_shards.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2023-01-10 13:36:02 +0100
committerChristian Grothoff <christian@grothoff.org>2023-01-10 13:36:02 +0100
commit1df72de087db8e2a0696fc5d8b8c3b1f8f3c8e80 (patch)
treea923182e74f864f2400d8ea64198cfba3e4883ca /src/exchangedb/0002-work_shards.sql
parentb41ffd1a1af24efc244f7ed95dcc13c4b77bc56e (diff)
parent0cf46d8e5995f84a642795ddf214776ed8d4077f (diff)
Merge branch 'master' of git+ssh://git.taler.net/exchange
Diffstat (limited to 'src/exchangedb/0002-work_shards.sql')
-rw-r--r--src/exchangedb/0002-work_shards.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/src/exchangedb/0002-work_shards.sql b/src/exchangedb/0002-work_shards.sql
index 016207d3..220745d4 100644
--- a/src/exchangedb/0002-work_shards.sql
+++ b/src/exchangedb/0002-work_shards.sql
@@ -49,3 +49,8 @@ CREATE INDEX work_shards_by_end_row_index
ON work_shards
(end_row DESC);
+CREATE INDEX work_shards_by_rows
+ ON work_shards
+ (job_name
+ ,start_row
+ ,end_row);