5.2 Computing the Spread to Use 119 The actual procedure might want to call itself recursively with smaller and smaller spread sizes when it finds a failure due to an absurdly large spread size. Then, if we reach a spread size of one, call a reorganization procedure. 5.2.3 Divisor via Formula The depth of a node in the tree is given by CREATE VIEW DepthFormula (emp_id, depth) AS SELECT O1.emp_id, COUNT(O2.emp_id) FROM Personnel_Orgchart AS O1, Personnel_Orgchart AS O2 WHERE O1.lft BETWEEN O2.lft AND O2.rgt GROUP BY O1.emp_id, O1.lft; The root will be at (depth = 1), and the depth will increase as you traverse to the leaf nodes. The depth column in the VIEW can be used as