Performance of Redshift Stored Procedure is not upto mark

Question

Hi All,
In my stored procedure, I have scursor which loops through the table and each record will go through many IF Conditions and as per result I will move further using fetch next while being inside loop itself.I am not able to do BULK UPDATE cause my requirement demand row level processing.It is performing good for just One id, but i have large number of ids which needs to be processed by this sp and time taken is beyond the expectation.How to speed up this stored procedure in Redshift?

AWS_Dylan · Answer

Hello,

Thank you for posting your question.

To further dive deep on the specifics of the slow execution of this stored procedure, I would ask that you [open a support case](https://us-east-1.console.aws.amazon.com/support/home?region=us-east-1#/case/create) and include the output of:

SHOW PROCEDURE sp_name

Reference: https://docs.aws.amazon.com/redshift/latest/dg/r_SHOW_PROCEDURE.html

Performance of Redshift Stored Procedure is not upto mark

Relevant content