Re: Looping (cursor) in SP giving performance delays
Posted by:
Uma Ram
Date: March 05, 2020 05:58PM
Thanks Peter!
More selects in SP giving better performance rather than cursor, (fetch the values and assign them into variables and from there get the best min value).Hope we will keep this code unless until if we notice any weird issue.
Subject
Views
Written By
Posted
742
March 04, 2020 06:30PM
420
March 04, 2020 08:16PM
Re: Looping (cursor) in SP giving performance delays
352
March 05, 2020 05:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.