diff options
| author | Brendan Abolivier <babolivier@matrix.org> | 2019-10-30 15:58:05 +0000 |
|---|---|---|
| committer | Brendan Abolivier <babolivier@matrix.org> | 2019-10-30 15:58:05 +0000 |
| commit | 233b14ebe1d96bd7cc3fcca09663794490186ad2 (patch) | |
| tree | eb550f661155c5f5a41890f86a12e14620f5d1a2 | |
| parent | Implement filtering (diff) | |
| download | synapse-233b14ebe1d96bd7cc3fcca09663794490186ad2.tar.xz | |
Add index on label
| -rw-r--r-- | synapse/storage/data_stores/main/schema/delta/56/event_labels.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/synapse/storage/data_stores/main/schema/delta/56/event_labels.sql b/synapse/storage/data_stores/main/schema/delta/56/event_labels.sql index 323d797419..9550b0adaa 100644 --- a/synapse/storage/data_stores/main/schema/delta/56/event_labels.sql +++ b/synapse/storage/data_stores/main/schema/delta/56/event_labels.sql @@ -17,4 +17,6 @@ CREATE TABLE IF NOT EXISTS event_labels ( event_id TEXT, label TEXT, PRIMARY KEY(event_id, label) -); \ No newline at end of file +); + +CREATE INDEX event_labels_label_idx ON event_labels(label); |