Skip to Main Content
  • Questions
  • Default order of the child rows of a parent in a hierarchical query

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Octavio.

Asked: December 14, 2016 - 5:35 pm UTC

Last updated: December 15, 2016 - 2:42 am UTC

Version: Oracle 10g Release 2

Viewed 1000+ times

You Asked

Hi Tom!:

In a heap table with hierarchical data, is it possible to affirm something on the default order of the child rows of a parent in a hierarchical query when the clause 'order siblings by' is not used?

Thanks!

and Connor said...

Not really - it would depend on the algorithm used, and the indexes available.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks!

A reader, December 15, 2016 - 2:45 am UTC