From af6e0f6ad313ca7482d3eb52c1dcd946c72b0aca Mon Sep 17 00:00:00 2001 From: Taras Madan Date: Wed, 11 Dec 2024 15:46:09 +0100 Subject: pkg/coveragedb: add (session, manager) index to files `select count(distinct session) from files` works as fast with multicolumn index as before. --- tools/syz-covermerger/init_db.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'tools') 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 \ -- cgit mrf-deployment