SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance issues with CONNECT BY level

2942624Aug 26 2016 — edited Aug 26 2016

Hi,

we have query which has Connect By level with where condition.

select * FROM acct_det
WHERE acct_type is NOT NULL
CONNECT BY level <= 5

This statement is working fine without 'where' condition But, when I include WHERE clause, the query runs forever without result.

Any suggestions on optimizing the query would be helpful

Thanks in advance..

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2016

Added on Aug 26 2016

9 comments

8,008 views