Performance Issue

[former_member650190]

Hi Team,

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

Thanks

Niket

[FredericGirod]

Give your example, performance are always specific case

[Sandra_Rossi]

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?