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
V
volodarzky2019-06-08 14:31:17
What could be the problem with accessing static.oracle.com? 0Reply
P
Perfection2019-06-18 09:58:37
What online SQL course is similar to Oracle University? 2Reply
N
NightFantom2015-01-25 19:47:54
What should be done to connect to Oracle DB as SYSDBA? 2Reply
R
Rammstein0072021-02-08 23:27:00
Why does hibernate try to update oracle materialized view when select is requested? 0Reply
S
stdio962017-02-09 05:05:11
How to register an account in Oracle CRM on Demand? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question