Self referencing table vs. tree traversal method
From: Chun-Yen <agi_at_haa.com.tw>
Date: Fri, 22 Sep 2000 13:38:28 GMT
Message-ID: <8qfnci$q7p$1_at_nnrp1.deja.com>
Date: Fri, 22 Sep 2000 13:38:28 GMT
Message-ID: <8qfnci$q7p$1_at_nnrp1.deja.com>
Hello, theres
as you know that using start with... connect by in Oracle can
help u simply to construct the tree structure.
How to design the table to get better performance without
using "start with... connect by" usage ???
Any better solution than this methods follows ??
pls have a look at follows
http://www.devdex.com/sql/message.asp?p=581&ID=%3CX2Dr5%2E554661%
24MB%2E8368976%40news6%2Egiganews%2Ecom%
Any idea ??
Agi
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Sep 22 2000 - 15:38:28 CEST