diff options
| author | Taras Madan <tarasmadan@google.com> | 2024-12-11 15:46:09 +0100 |
|---|---|---|
| committer | Alexander Potapenko <glider@google.com> | 2024-12-12 10:14:40 +0000 |
| commit | af6e0f6ad313ca7482d3eb52c1dcd946c72b0aca (patch) | |
| tree | 5d87fd2a9ce69f1b745f41f9803253478831d44d /tools | |
| parent | 941924ebb4fc1ba15d5d3f12730ce32d7a6ace5f (diff) | |
pkg/coveragedb: add (session, manager) index to files
`select count(distinct session) from files` works as fast with multicolumn index as before.
Diffstat (limited to 'tools')
| -rwxr-xr-x | tools/syz-covermerger/init_db.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/tools/syz-covermerger/init_db.sh b/tools/syz-covermerger/init_db.sh index 4aa4fdaa7..75a4319f3 100755 --- a/tools/syz-covermerger/init_db.sh +++ b/tools/syz-covermerger/init_db.sh @@ -26,7 +26,7 @@ gcloud spanner databases ddl update $db --instance=syzbot --project=syzkaller \ --ddl="$create_table" echo "creating 'files' index" gcloud spanner databases ddl update $db --instance=syzbot --project=syzkaller \ - --ddl="CREATE INDEX files_session ON files (session);" + --ddl="CREATE INDEX files_session_manager ON files (session, manager);" echo "drop table 'merge_history' if exists" gcloud spanner databases ddl update $db --instance=syzbot --project=syzkaller \ |