Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Performance Issue

former_member650190
Discoverer

‎2022 Nov 21 2:13 PM

0 Likes
883

Hi Team,

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

Thanks

Niket

Hi Team,

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

Thanks

Niket

Reply
2 REPLIES 2
Read only

FredericGirod
Active Contributor

‎2022 Nov 21 2:21 PM

820

Give your example, performance are always specific case

Read only

Sandra_Rossi
Active Contributor

‎2022 Nov 21 5:11 PM

0 Likes
820

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?