Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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?

Comments

Processing

Post Details

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
591 views