topic Performance Issue in Application Development and Automation Discussions

Performance Issue

former_member650190 — Mon, 21 Nov 2022 14:13:52 GMT

Hi Team,

Can anybody let me know which is better to use parallel cursor or reduce operator for nested loops.

Thanks

Niket

Re: Performance Issue

FredericGirod — Mon, 21 Nov 2022 14:21:25 GMT

Give your example, performance are always specific case

Re: Performance Issue

Sandra_Rossi — Mon, 21 Nov 2022 17:11:20 GMT

As always, the meaning of "better" depends on the context. If you have a high volume of data, it could be better to use "parallel cursor" on 2 internal tables but the code is less maintainable, and with a low volume of data it could be better to use REDUCE because it's more important to have maintainable code. But of course, there are other factors to consider.

Interview question?