When to change default in functions specifying rows = 1000

What are the ramifications of never changing the “rows = 1000” default in your functions?

What if the function usually returns 50K rows?

What if it usually returns 1 row?

1 Like