diff options
Diffstat (limited to 'queries/index.sql')
| -rw-r--r-- | queries/index.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/queries/index.sql b/queries/index.sql new file mode 100644 index 0000000..5af21b5 --- /dev/null +++ b/queries/index.sql @@ -0,0 +1,4 @@ +CREATE INDEX ON match((data->>'id')); +CREATE INDEX ON roster((data->>'id')); +CREATE INDEX ON participant((data->>'id')); +CREATE INDEX ON match((data->'attributes'->>'createdAt')); |