MySQL Forums
Forum List  »  Stored Procedures

Procedures or function using set command
Posted by: Phil Siyam
Date: January 24, 2022 07:35AM

We recently upgraded from 8.0.24 to 8.0.26. Any procedures or function using set command are very slow and we have been changing set to into. E.g

-- Old Query
set var_1 = (select col1 from tab1 where col2 = 11);

-- New Query
select col1 into var_1 from tab1 where col2 = 11;

Is there better way to do it?

Thanks in advance.

Options: ReplyQuote

Written By
Procedures or function using set command
January 24, 2022 07:35AM

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.