08-24-08, 11:54 #1Registered User
- Join Date
- Aug 2008
Unanswered: connect by - performance/ alternate options
hi, we are storing hierarchical data in Oracle databasse. we are planning to use connect by to retrieve hierarchial data using a single query. I read on internet that connect by cause full table scan and impacts the performance. Is this performance of the query dependant on the number of rows in a table or the number of levels in a node. We have different sets of tree data. For example, a tree can have many nodes. Does the performance impact based on how many levels a node has or is it dependent on the number of nodes i.e., for example a tree may have 2500 nodes, but max no of levels can be not more than 6 from root? Which one impacts the performance (the no of total nodes or the max no of levels?)
Do we really need to worry about performance using connect by? Is there any alternate options?
08-24-08, 14:05 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
Why do you prefer to trust feedback from unknown stangers over simply performing your own reproduciable benchmarks test runs?You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.