Hello Experts,
I have this question:
Given the hierarchal data, should I choose the hierarchal query using CONNECT BY or the one that uses Recursive WITH Clauses ?
I mean which one is efficient when table has millions of records ?
I do understand the advantage that Recursive Sub query factoring offers BREADTH FIRST BY and DEPTH FIRST BY to order the data.
Please guide me as to which is more efficient.
Regards,
Ranagal