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
Regards,
Jithesh
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.