Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
S
S
StayAtHome2015-03-04 17:58:52
Oracle
StayAtHome, 2015-03-04 17:58:52

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

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

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
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.

Similar questions
S
sflyer2017-04-06 07:15:08
Php+Oracle increment by invalid variable name/number, how to write correctly? 2Reply
D
Djasar2021-03-29 21:12:09
Can't merge tables correctly, what am I doing wrong? 2Reply
R
rageorg2019-09-18 18:14:56
How to set up "multi-user" using Spring hikariCP? 1Reply
R
Roman_ Outside2015-04-30 15:10:01
How to get ER diagram from Oracle database? 1Reply
B
Botu2015-05-14 07:29:07
What is the sequence in parsing select unique ... at oracle? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question