Simple say is I have three nested inside a stored procedure for loop. Lead to slow performance data to run not to come out, would you please tell me what the method to optimize the great god?

The CREATE OR REPLACE PROCEDURE aaaa
Is the begin
For a in 1.. 100 loop
For in 1 b.. 100 loop
For c in 1.. 100 loop
End loop;
End loop;
End loop;
End aaaa.

CodePudding user response:

This can only be combined with business to optimize

CodePudding user response:

See you what you wrote,

CodePudding user response:

According to the specific business scenario, do the equivalent to rewrite the SQL,

CodePudding user response:

According to the specific business do equivalent,

CodePudding user response:

You need more specific business needs