Love to Performance : CONNECT BY PRIOR in Oracle Performance Issue
CONNECT BY PRIOR clause is Oracle provided a great solution for hierarchical queries but connect by prior in Oracle performance issue are headache. It’s because of large dataset misuse of