Performance issues with connect by clause with Trees

[Jerry Kight <Jerry_Kight@AONCONS.COM>]

I have a very rudimentary tree set up using tree-manager in Peoplesoft
(Oracle 7)

When I use the "connect by" clause with a "start with" as the first
tree_node_num in the tree, it takes a couple of hours to run.

Any ideas on how performance can be tuned?

SELECT  SETID,
TREE_NAME,
 EFFDT,
TREE_BRANCH,
TREE_NODE_NUM,
TREE_NODE,
TREE_LEVEL_NUM,
TREE_NODE_TYPE,
PARENT_NODE_NUM,
TREE_NODE_NUM_END
FROM PSTREENODE
    WHERE   SETID = 'ACSHR'
START WITH  TREE_NODE_NUM = 1
CONNECT BY PRIOR  TREE_NODE_NUM =  PARENT_NODE_NUM;