Skip to Main Content
  • Questions
  • Using hierarchical query and its impact


Question and Answer

Connor McDonald

Thanks for the question.

Asked: November 30, 2023 - 12:52 pm UTC

Last updated: December 04, 2023 - 6:22 am UTC

Version: 19c

Viewed 1000+ times

You Asked

Hi Tom,

I do have a large table millions of records. and the levels are much deeper it would vary case to case

In order to achieve the results, whether hierarchical query is good or some other approach suits the purpose



and Connor said...

Well, if you want to traverse a hierarchy, then a hierarchical query is pretty much the only way to go.

In terms of performance, you might want to try both methods and see which is best

1) connect-by
2) recursive with

But in either case, I'd contend that doing something home grown probably wont perform as well as using the supplied facilities unless you have a very niche set of data.