3 lines · 197 B
-- Sweeps page through the scopes holding one kind of row (`locatedScopesFrom`) instead of reading them all.
CREATE INDEX IF NOT EXISTS scope_locators_kind_scope ON scope_locators(kind, scope_id);