Re: script taking time

Posted by ErmanArslansOracleBlog on Jun 06, 2018; 7:11am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/script-taking-time-tp6155p6175.html

Try creating indexes on the columns that are used in the where condition.
But, always remember, having indexes on tables also slows down the DML performance.
So, you should be working on this with your developers, who knows the tables, data , queries and the application.