What is the best way to use for building hierarchical queries on Oracle?

S

StayAtHome2015-03-04 17:58:52

Oracle

StayAtHome, 2015-03-04 17:58:52

What is better to use on Oracle to build trees - the old connect by or new recursive queries (from version 11)? Tree ~ 5-10 thousand nodes with 3-5 levels of nesting, aggregated counts by nodes are required.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

Markus Kelvin, 2015-03-19
@mmxdesign

Rather than use connect by or recursive queries if there are such a number of nodes, look better towards transitive closures, they are just used in SQL tuning.