BEGIN;

CREATE INDEX hierarchy_parentid_idx ON hierarchy (parentId);

CREATE INDEX hierarchy_childid_idx ON hierarchy (childId);

COMMIT;