Oracle Database Discussions

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 issue in connect by level query

Mahendran PJul 31 2023 — edited Jul 31 2023

performance issue in connect by level query

The above table have 11 rows with start and end date. if execute, take more than 45 mins for this query.

I have created index for above columns. but not able to resolved this.

any suggestion for improve performance?

Added on Jul 31 2023

#database-and-application-migrations, #database-installation, #database-upgrade, #general-database-discussions, #oracle, #oracle-developer-tools-for-visual-studio, #pl-sql, #plsql, #sqldeveloper, #sqlplus

3 comments

844 views