duplicati/Duplicati/Library/Main/Database/Database schema/12. Performance Indexes.sql
2022-02-27 13:29:58 -07:00

12 lines
504 B
SQL

CREATE INDEX "nnc_Metadataset" ON Metadataset ("ID","BlocksetID");
CREATE INDEX "nn_FilesetentryFile" on FilesetEntry ("FilesetID","FileID");
-- Line 602 & 603 LocalBackupDatabase.cs
-- CREATE INDEX "tmpName1" ON "{0}" ("Path"),tmpName1
-- CREATE INDEX "tmpName2" ON "{0}" ("Path"),tmpName2
CREATE INDEX "nn_FileLookup_BlockMeta" ON FileLookup ("BlocksetID", "MetadataID");
CREATE INDEX "nnc_BlocksetEntry" ON "BlocksetEntry" ("Index", "BlocksetID", "BlockID");
UPDATE "Version" SET "Version" = 12;