BEGIN;

CREATE INDEX hierarchy_parentid_idx ON hierarchy (parentId);
CREATE INDEX hierarchy_childid_idx ON hierarchy (childId);

COMMIT;